Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

prevent expression from calculating for Months that have not yet occurred

I have the table below where I am calculating a CW Count per Month my Expression is Count (Distinct [CW ID]). 

The second expression calculated the difference between the Rows of the CW Count column

Expression is  If(RowNo(TOTAL) = 1, 0, (Count (Distinct [CW ID])) - Above(Count (Distinct [CW ID])))

Question 1:  How can I prevent the CW Count from calculating for Months that have not yet occurred.  For example, I would want the table to end at March.

Question 2:  How do I prevent the Monthly Difference column from calculating when the CW Count row is 0?

This is what I would like to see.

10 Replies
brf10043
Creator
Creator
Author

Thanks Sunny!