topic Straight table with input boxes: hide rows that do not match in QlikView

Straight table with input boxes: hide rows that do not match

Tue, 08 Apr 2014 13:16:04 GMT

Hi,

I have a straight table that shows several fields for product information, and a monetary value as expression (although it is not really an expression, as already calculated during the load)

I now added an input box with two variables to be able to filter for product within that range:

=only(if([TCV Reportet (Produkt).P] >= vMin and [TCV Reportet (Produkt).P] <= vMax, [TCV Reportet (Produkt).P]))

This is working, except for the fact all the products that do not match remain in the list with a value of '-'. How can I filter them to only show rows matching the input box values?

Thanks

Jens

Re: Straight table with input boxes: hide rows that do not match

Roop — Tue, 08 Apr 2014 15:42:48 GMT

I assume that you are using a chart ..... ?

I assume that the above is for a calculated dimension or filter .....

You will need to ensure that the expression is null or zero too to ensure that the values do not appear. So you need to put the above expression round your existing expression and ensure zeroes are not displayed.

Re: Straight table with input boxes: hide rows that do not match

Wed, 09 Apr 2014 05:50:13 GMT

Yes, a straight table chart.

The above is one of the expressions.

How can I set all others to null to let these rows disappear?

Re: Straight table with input boxes: hide rows that do not match

Wed, 09 Apr 2014 05:55:50 GMT

if( len(<your expression>)>0, <your expression>)