Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
hannibal2395
New Contributor II

Remove zero values from Pivot Table

Hi,

I have following pivot table

CustLYCYWin/Loss

abc7.490Lost
xyz59.35103.62-
pqe121.6896.23-
stu12.61-
wxy14.370Lost
zuc43.710Lost
anc22.3326.14-
aksbd1,087.081,262.62-
asdnmasd105.090Lost
asnkasc12,129.003,456.92-
absjcjasc10.080Lost
amc a80.040Lost
 asmc ac7.348-
a cmzx ck192.27112.89-
anmsc mas 5.330Lost
m,as casc1,572.361,405.94-
asvcuiac27.4412.64-
acvkac 8.823.85-
 ajkcka 1.735.54-
a cjkakc 08.39Win

 

From which Column "Win/Loss" is measure and i want to remove all the values which are null.

How can i do that?

Please Suggest.

Labels (2)
1 Reply
Partner
Partner

Re: Remove zero values from Pivot Table

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.png

2. In the "Add-ons" tab you need to uncheck "Include zero values"

1.png

Regards, Igor.