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

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

pivot table

I am calculating count of orders on dimensions Name and Month. I need only 4 months to display, from Sep to Dec. How can I do this in expression.Thanks

2 Replies
Not applicable
Author

Perhaps you could try something like:

count({<month = {">=Sep <=Dec"}>}Orders)

Hope that helps.

Matt

Not applicable
Author

 

=avg({<[Curative TR Month] = {'Sep','Oct','Nov','Dec'}>}[Curative Turntime]/43200)