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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!