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: 
bartwelvaarts
Contributor III
Contributor III

check total of previous moths

hello friends of the Qlik community,

I have 4 columns whch all have a different calculated amount.
In the first column i want to calculate the amount of the not selected months (which works perfectly ) but i only want to see the records of the month(s) i selected for column 3 & 4 in the same 'month' filter.

when i select a month now, i get the results of all the months in the first column (because there is data) and the other columns are 0 in most of the cases. But the amount of the month i select can be 0 as well (ordernr 10)
So i cannot just exclude the 0 values.

I hope anyone can help me with this?

i added an example below

0 Replies