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
