Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahmooddba
New Contributor II

Hide Record

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

1 Solution

Accepted Solutions
felipedl
Valued Contributor III

Re: Hide Record

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)

Sample.png

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

Sample.png

4 Replies
felipedl
Valued Contributor III

Re: Hide Record

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)

Sample.png

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

Sample.png

mahmooddba
New Contributor II

Re: Hide Record

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
Valued Contributor III

Re: Hide Record

Mahmood,

The option is available in the Cloud version,

Sample.png

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

mahmooddba
New Contributor II

Re: Hide Record

Thanks!

Community Browser