topic Re: Qlikview - Filter on Expression in QlikView

Qlikview - Filter on Expression

abhilash27 — Sat, 16 Nov 2024 00:46:58 GMT

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

Re: Qlikview - Filter on Expression

rubenmarin — Mon, 27 Apr 2020 11:14:55 GMT

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))

Re: Qlikview - Filter on Expression

abhilash27 — Mon, 27 Apr 2020 13:37:30 GMT

That worked! Thank you very much, Rubenmarin.