Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
I knew it was something very simple. You are amazing! Thank you so much!
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.