topic Re: Suppressing Rows based on the expression value in QlikView

Suppressing Rows based on the expression value

avinashkk696 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a requirement where I have a table with columns Customer, State and Sales. In the straight table I am taking Customer, State as Dimensions and Sum(Sales) as expression.

Expected output is,

I want to suppress row which has expression >0. Any Ideas??

Thanks in advance.

Re: Suppressing Rows based on the expression value

avinashelite — Fri, 26 May 2017 13:21:42 GMT

Try this in expression

if(Sum(Sales) =0,Sum(Sales) )

and un-check the suppress zero values in the presentation tab and check suppress null

Re: Suppressing Rows based on the expression value

avinashelite — Fri, 26 May 2017 13:22:27 GMT

Sum({<Sales={0}>}Sales)

Re: Suppressing Rows based on the expression value

MK9885 — Fri, 26 May 2017 13:25:29 GMT

Not sure about your supress thing Maybe try

if(sum(sales)>0,sum(Sales),0)

This will only show values greater than 0

if(sum(sales)<0,sum(Sales),0)

This will show values less than 0.

But you can just Supress Null in Dimensions instead of writing an expression. That would be more easier.

Properties>Dimensions>

Below you'll find a check box to supress null for dimensions

Re: Suppressing Rows based on the expression value

ahaahaaha — Fri, 26 May 2017 13:36:01 GMT

Hi,

may be as attached file

Andrey

Re: Suppressing Rows based on the expression value

ahaahaaha — Fri, 26 May 2017 13:39:45 GMT

Add expression 1 to show all the lines, including zero (then hide the field in the settings of the table). Further in fields SUM(SALES) and 1 add Set Analysis expression {<Customer={"=Sum(Value)=0"}>}.

Re: Suppressing Rows based on the expression value

avinashkk696 — Fri, 26 May 2017 13:41:40 GMT

Thank you Avinash and Aehman, I have tried your expressions i'm getting the output as below.

I have also unchecked suppress zero values and checked suppress missing. Its not working. I can not suppress dimension as i don't know the value of the expression. So need to suppress row based on the expression.

Re: Suppressing Rows based on the expression value

avinashelite — Fri, 26 May 2017 14:33:16 GMT

Try this in your dimension

=if(Aggr(sum(Sales)=0,Customer,STATE),Customer)