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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
engr_farhanqadr
Creator
Creator

Multi selections in set analysis

Hi folks,

I am using the below formula , it is working fine when  I select Year and then one value for Quarter. like q1 or q2

but I want to multi select in quarter field for 6 months or 9 months what to change in below formula.  

sum({<Year=,Quarter=,YearlyQuarter=,
[settle_master.Year]=,[settle_master.Month]=,
[Master_INTIMATION.Year]=,[Master_INTIMATION.Quarter]=,[Master_INTIMATION.Month]=
,[Master_INTIMATION.YearlyQuarter]={"<$(=GetFieldSelections(YearlyQuarter))"}
,[settle_master.Year]={">=$(=GetFieldSelections(Year))"}, [settle_master.YearlyQuarter]={">=$(=GetFieldSelections(YearlyQuarter))"} >} PAID)
+
sum({<Claim_settle_date={'N/A'},[Master_INTIMATION.Year]={"<=$(=GetFieldSelections(Year))"},
[Master_INTIMATION.YearlyQuarter]={"<$(=GetFieldSelections(YearlyQuarter))"},
Year=,Quarter=,YearlyQuarter=,
[settle_master.Year]=,[settle_master.Month]=,
[Master_INTIMATION.Quarter]=,[Master_INTIMATION.Month]=>} PAID)

Thanks.

 

Labels (2)
0 Replies