Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
JLob
Contributor II
Contributor II

How do I show specific values in a pivot table?

So I have a pivot table chart made for my visual. I'm displaying a percentage value for all the locations based on month and quarter. The locations are on the left, but left them out to protect identity. The client wants the location that has "0%" values to not be added to the visual because it's a new location at the present moment (so it's an outlier). So my understanding is that the client wants anything >0% to be shown without changing the data or the custom query. So I want to change the visual alone. How would I do that on my visual? Sorry new to Qlik Sense.

zeropercent.png

Labels (1)
3 Replies
rubenmarin1

Hi, if you edit the sheet, on the properties pannel -> add-ons section, there is an option to include zero values, uncheck it to remove that row.

You can also use set analysis to exclude some value like: Sum({<Customer-={'CustomerToExclude'}>} value)

JLob
Contributor II
Contributor II
Author

I knew it was something very simple. You are amazing! Thank you so much!

vish123
Creator III
Creator III

Hi Jlob,

you can try 

if (Metric = 0, null(), location)

or 

if (jan =0 and Feb = 0 and Mar= 0 , null(), location)

you can switch off null values in pivot table settings. Hope this helps.