Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

3 Replies
rupe
Valued Contributor

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

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.

Not applicable

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

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?

Not applicable

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

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

Community Browser