Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

Set analysis

Hi Everyone,

Can any one please help me on below logic.

I have taken the below logic in the KPI, its showing only maximum month related count.

=Sum(if(Aggr(Max({$<MonthYear={'$(=$(vG.CurrentPeriod))'}>}[RAG ind]),[Metric Group],Metric)=2,1,0))

But in another KPI i have to show all the months related count by including [Metric Group] = 'Entertainment' also need to avoid the {"'-'"}, in the Metric group.

Please help me what changes i need to do on the above expression as per the requirement,

Thanks in advance.

1 Reply
Honored Contributor II

Re: Set analysis

Not sure if the below expression would work?

=Sum(if(Aggr([Metric Group]-={'-'}, [Metric Group] = {'Entertainment'}>}[RAG ind]),[Metric Group],Metric)=2,1,0))

Neglecting '-' and including Entertainment plus not using Max of Months which would give all months, I guess so.

Community Browser