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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression help..

Hi All,

I have to write an expression for -on selection of a particular month i want count of material whose production qty is 0 for the selected month as well as for its previous month.

kindly help.

Regards

2 Replies
MK_QSL
MVP
MVP

COUNT(Distinct {<Month = {'$(=Max(Month))'}>}material) + COUNT(Distinct {<Month = {'$(=Date(Max(Month)-1,'MMM'))'}>}material)

Not applicable
Author

I also need to insert Production qty condition in expression