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)