Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community Experts,
Can I get the below expression fully in set analysis without using if condition.
IF(GetFieldSelections(Product,';')='AA;BB' or GetFieldSelections(SubProd,';')='AAA;BBB',SUM({$<ProdType-={'SmartPhone'}>}Amount),
IF(GetFieldSelections(Product,';')='CC;DD' or GetFieldSelections(SubProd,';')='CCC;DDD',SUM({$<ProdType-={'Mobile'}>}Amount),
SUM({$<ProdType-={'SmartPhone','Mobile'}>}Amount)))
Thanks lot
Hi,
Check out 'GetFieldSelections + SetAnalisys' in Qlik Community.