Discussion board where members can get started with Qlik Sense.
I have following pivot table
From which Column "Win/Loss" is measure and i want to remove all the values which are null.
How can i do that?
You can try this:
1. In all other measure you must change expression. For example your if original expression for measure LY was "SUM(Sales)", then you must write
if(not IsNull(YourWinLoseDimension), SUM(Sales))
After that action, all measure that corresponds null values in Win\Loss column will bу assigned to null too.
2. In the "Add-ons" tab you need to uncheck "Include zero values"