Hide Record

[mahmooddba]

I would like to hide the record if measure value is zero

[felipedl · Accepted solution]

Hi Mahmood,

You can simply hide the "Include zero values" in the Complement tab on the graph (my sense is in portuguese, so the names are translated and might be a little different, but i've attached some images as examples bellow).

Heres my sample data i used:

Load * Inline

[

ID,Value

    1,10

    2,0

    3,5

    5,100

]

And two example images:

(with option marked, showing the label 2 in the dimension)

(without option marked, not showing the label 2 in the dimension)

[mahmooddba]

Hi Felip,

Thanks for your response I am using web version of Qlik Sense and couldn't find this option. I am new to Qlik Sense can you please recommend the best way of development either by Desktop version or Web.

[felipedl]

Mahmood,

The option is available in the Cloud version,

Go to the third option, from the top down, and data manipulation (as shown in the image).

[mahmooddba]

Thanks!