Qlikview - Filter on Expression

[abhilash27]

Hi,

I have a pivot table visual, with 4 dimensions and 3 measures - please refer to the attached image. I want to filter out records with Total Volume less than 20. Can I get some recommendation on how I can acheive that. Of the 4 dimensions, Origin City and Mode are calculated dimensions.

Thank you,

Abhilash

[rubenmarin · Accepted solution]

Hi, if you want to show less than 20 filtering all dimension you can simple set an If() before it calculates the expression:

If(Sum(Volume)<20, Sum(Volume))

If(Sum(Volume)<20, Avg(DaysToLoad))

[abhilash27]

That worked! Thank you very much, Rubenmarin.