topic Re: Hide Rows based on expression in a Straight Table in QlikView

Hide Rows based on expression in a Straight Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a straight table with 7 dimensions and 5 expressions. I want to hide rows of the straight table based on 1 expression(its amount > 10) How can I achieve this. I only want to see rows where the expression amount is greater than 10.

Really appreciate any help.

Re: Hide Rows based on expression in a Straight Table

francisvandergr — Thu, 11 Aug 2016 20:49:20 GMT

if (sum(Amount) > 10,sum(Amount))

Re: Hide Rows based on expression in a Straight Table

Thu, 11 Aug 2016 20:57:44 GMT

Where should I add this? Expression or Dimension?

Re: Hide Rows based on expression in a Straight Table

francisvandergr — Thu, 11 Aug 2016 21:15:20 GMT

In the expression

Re: Hide Rows based on expression in a Straight Table

francisvandergr — Thu, 11 Aug 2016 21:16:36 GMT

Send otherwise an example if you like

Re: Hide Rows based on expression in a Straight Table

mmonfort — Fri, 12 Aug 2016 00:05:39 GMT

Per Francis' response and depending on your data you might still see those dimensions show up - if that's the case make sure on the dimensions you have ticked the "suppress when value is null" check box

Re: Hide Rows based on expression in a Straight Table

Fri, 12 Aug 2016 16:54:46 GMT

Thanks, it worked. But now I have 2 expressions, and I need to have a check on both Amount and profit and hide rows if both Amount>10 and Profit > 2. How can I achieve this?

If I'm putting condition on both, it is still showing even if Amount >10 and Profit <2.

Re: Hide Rows based on expression in a Straight Table

vishsaggi — Fri, 12 Aug 2016 17:09:21 GMT

Can you post the full expression you are using in evaluating this condition. Use OR instead of AND and try?

Re: Hide Rows based on expression in a Straight Table

Fri, 12 Aug 2016 18:45:18 GMT

There are two different expressions which are creating Amount and profit. Where should I put the AND or OR condition?

Re: Hide Rows based on expression in a Straight Table

vishsaggi — Fri, 12 Aug 2016 18:53:25 GMT

Can you share a sample app if possible please ??

Re: Hide Rows based on expression in a Straight Table

francisvandergr — Fri, 12 Aug 2016 21:30:35 GMT

Here you have an example. If you need something else please let us know by your example

Re: Hide Rows based on expression in a Straight Table

Sat, 13 Aug 2016 05:39:29 GMT

hi,

Hide a row in straight table

Re: Hide Rows based on expression in a Straight Table

mmonfort — Mon, 15 Aug 2016 12:38:34 GMT

I had something similar as well - I had 2 expressions that needed conditions on them.

If I were you I'd write it like this

Expression 1:

if(sum(Amount)> 10,
if(sum(Profit)> 2,
sum(Amount) ))

Expression 2:

if(sum(Amount)> 10,
if(sum(Profit)> 2,
sum(Profit)))

Does that work for you?