Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm hoping someone can take a look at the attached sample file and tell me if it's possible to set up qlikview to filter rows out of the pivot table based on the sum(amount) expression using a variable/slider.
I'd like to set it up so that it only displays rows in the pivot table when the 2019 sum(amount) value is greater than or equal to the value set by the slider.
Is that possible to do?
Try changing the expression to:
If(sum(Amount)>$(vThreshold), sum(Amount))
Try changing the expression to:
If(sum(Amount)>$(vThreshold), sum(Amount))