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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show dimension values in a chart based a condition

Hi folks,

I have this chart that shows the evolution (by month) of evaluation (good, regular, bad) of projects. I have 32 projects but I only want to show values for a specific month if all the 32 projects have the evaluation.

Ex:

October - 32 projects evaluated

November - 32 projects evaluated

December - 10 projects evaluated

In my chart will be shown only October and November.

I tried using some aggregation in the Date dimension like this below, but didn't work.

=if(aggr(count(dat_evaluation_project),month_evaluation_project)=32 , date(dat_evaluation_project,'MMM/YY'))

Any ideas?

Thanks in advance.

0 Replies