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

Aggregation within the count function

Hello friends


For every Date I want count KPI_names where avg KPI_value by KPI_name <1 

i try this expression, but it doesnt work

= count ( {<aggr(avg(KPI_value), KPI_name) ={'<1'}>} distinct KPI_name)

Let me know if  anyone has idea or decision of this.


Thank you in advance

Ruslan



10 Replies
Not applicable
Author

Thanks Sunny for provided solution!