Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
varunreddy
Contributor III

Set Analysis inside set analysis

Hi All,

I need your help with one of the expression. Not sure why it is doing it. Hoping you guys will help fix it.

I have a dimension 'Name' and I want to calculate all the months where the count(ID)>6. I want this expression in the front end.

This expression is working fine when the Name is selected, else it is giving all the months available for that Name.

 

Expression:

Count({<Month= {"=(Count({<Year={$(=vMaxYear)}>} ID))>6"}>} Distinct Month)

 

Can anyone please help me understand why it is working when the Name is selected, else displaying all the available dates in that year that is associated to that name?

 

Thanks in advance!

4 Replies

Re: Set Analysis inside set analysis

This should work when you not selecting as well. Provide some application to test.

Second part, Try this?

If(GetSelectedCount(Name)>0, Count({<Month= {"=(Count({<Year={$(=vMaxYear)}>} ID))>6"}>} Distinct Month), ' ')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
varunreddy
Contributor III

Re: Set Analysis inside set analysis

Hi,

What do you mean by second part?

 

 

 

varunreddy
Contributor III

Re: Set Analysis inside set analysis

As my dimension is Name, else condition cannot be ' '. We need to display the count of Months where count of Loan ID >6. Can you please suggest any options?

Re: Set Analysis inside set analysis

Perhaps this?

 Count({<Month= {"=Count(LoanID)>6"}>} Month)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)