topic Suppress row when variables outside range in QlikView

Suppress row when variables outside range

mp802377 — Wed, 21 Feb 2018 21:25:40 GMT

Hello,

I have a straight table with several fields and two expressions. The two expressions are for the total duration and total cost. I have 4 sliders. One for the minimum duration, one for maximum duration, one for minimum cost, one for the maximum cost (they really wanted sliders).

Here is the issue. When they change the duration let's say between 9 and 10 hours, instead of the row disappearing that has a total duration of 8 hours, the sum of the duration in the table changes to a 0. I have suppress null values and suppress zero-values checked and that does nothing.

The same issue is with the cost as well. I think it is because they are both in the same straight table but I really need them to be.

Thank you for your help!

Martha

Re: Suppress row when variables outside range

marcus_sommer — Thu, 22 Feb 2018 13:24:00 GMT

I think you need both conditions in both expressions maybe something like:

sum({< Duration = {">=$(vMinDuration)<=$(vMaxDuration)"},

Costs = {">=$(vMinCosts)<=$(vMaxCosts)"}> Duration)

- Marcus

Re: Suppress row when variables outside range

mp802377 — Thu, 22 Feb 2018 14:04:07 GMT

Thank you so much! Such an easy fix.