take action when two specific values are selected in a Qlikview listbox -
take action when two specific values are selected in a Qlikview listbox -
quick qlikview 11 question: have listbox associated customers (a column database table). of course, customers tables has many different values, interested in showing "yes" in textbox when values "customer a" , "customer b" selected user listbox. tried far:
=if(customers="customer a" , customers="customer b", "yes", "no")
this doesn't work. (i obtain "no" result instead of "yes", despire fact 2 mentioned values selected listbox) help much appreciated. give thanks you.
well, found work:
if( substringcount ( getfieldselections(customers),'customer a,customer b') >= 1 or substringcount ( getfieldselections(customers),'customer b,customer a') >= 1 , 'yes', 'no')
if has other ideas, sense free mention them. 1 possible solution.
listbox qlikview
Comments
Post a Comment