Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ranibosch
Creator
Creator

filter on object

good day,

I have a pivot table as an object on my sheet.

I sum the total quantity items sent to quarantine, total quantity purchased, and then I show the quarantined items as a % of total purchases.

this is done per lot no.

how can i filter out the 0 quarantine quantities out of my pivot table?

1 Reply
ErikWetterberg

Hi,

The easiest way to do this is to use a Limitation as described here:

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Visualizations/PivotTable/pivo...

To make this work you would probably have to make quarantine quantity your first measure.


Hope this helps


Erik Wetterberg