Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

Count of records where Field>6

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!

 

 

 

Labels (1)
1 Reply
Anil_Babu_Samineni

Don't create duplicate for single issue Duplicate Here

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)