Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
niranjana
Creator
Creator

If condition

Hi All,

 I need to limit value sin dimension in Qliksense table. I have dimension as "Market" under which many products are there. Also, there are many markets. 

My requirement is if I select Market as "NS Range", all products except two products : pdt 1 and pdt 2 must be visible. If I select any other market, those corresponding products must be visible which is working fine. Only first case is not working. I want to change in dimension. 

Also the selection of Market in list box is a variable : vBrandMarket.

 

this is the expression in dimension: if(GetFieldSelections(Brand_Market)='NS Range',Brand_Product<>'Mayzent',Brand_Product) 

if(vBrandMarket={'NS Range'}, Brand_Product-={'Mayzent'}, Brand_Product),Brand_Product)

 

I tried if not match but its not wokring.

ANy help is appreciated.

Thanks

Labels (1)
0 Replies