CODEWITHSUNDEEP
countconditional-statementsexpressionqlikview
Abhilash
Abhilash

Reputation: 55

Qlikview - Count with Conditional Expression

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.

enter image description here

Upvotes: 0

Views: 616

Answers (1)

BrunoMarques
BrunoMarques

Reputation: 557

You can try something quick and dirty that will do the trick :

Sum(if(TotalVolume >= 20, TotalVolume))

It's valid for other measures, so you could also do :

Avg(if(TotalVolume >= 20, DaysToLoad)

The most efficient way would be to use a set analysis, something like :

Sum( {<TotalVolume = {">=20"}>} TotalVolume)

Upvotes: 1

Related Questions