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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

GetFieldSelections in Setanalysis

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

10 Replies
ilanbaruch
Specialist
Specialist

Hi,

Check out 'GetFieldSelections + SetAnalisys' in Qlik Community.