Removing rows from a Straight Table chart based on a variable

[#1]

Hi there,

I am sure this should be simple, but I am obviously missing something somewhere.

I have a QlikView document which is calculating a percentage, and showing this in a straight table. The percentage is based on current selections, and can not be derived at load time. What I would like is a slider with values from 0 to 100, and only rows above the selected value to show in the table.

I have the variable set up, the slider linked to it, and can change the text colour of the rows I want included based on the criteria. What I am stumped on is excluding the rows I don't want. Using an 'if' statement I have tried returning zero and null for rows to exclude, and using the check boxes for excluding these rows - but these options do not seem to work for me.

The attached QlikView document is a simple example of what I am trying to do. I would like the rows with nulls in the last column to not show. I suspect Set Analysis may be the answer, but could do with a quick pointer on how to achieve this.

Cheers,
Steve

[#2 · Accepted solution]

Hi Steve,

Please see attached. I removed some columns. Those columns will return a value and therefor the row where w/null is null() will still be displayed.

Regards

[#3]

Hi there,

Your example did indeed work, and when I went back to my original and put the If statement on all Expressions to return null on each column it worked fine there also. I didn't spot that the Suppress Missing and Suppress Zero options were not tied to an Expression, rather the entire chart.

I am getting much strangeness going on when I try and apply this back into my original document - but at least I know what I am aiming for now.

Many thanks,
Steve