Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mp802377
Creator
Creator

Suppress row when variables outside range

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

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

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

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

- Marcus

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

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

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

- Marcus

mp802377
Creator
Creator
Author

Thank you so much! Such an easy fix.