topic Hide rows with 0 in QlikView

Hide rows with 0

Wed, 23 Oct 2013 20:35:25 GMT

hi i have the following scenario, whereby i wish to hide rows that contain 0.

for all values that are 0 in this column i wish not to see them.

i am unable to find a function to make this work have tried supress zero without luck.

Anonymous — Wed, 23 Oct 2013 20:56:40 GMT

In Presentation Tab, select Period Value LC and Clik on Suppress zero values.. if not please upload sample..

Wed, 23 Oct 2013 21:06:28 GMT

If all do you want is something like this (image)

you can try the follow expression:

if ([Period value LC]>0, <expression>)

in each column that contains one expresión in your Table, always you must be evaluate the expresión [Period Value LC]