topic Re: omit record in the expression in QlikView

omit record in the expression

Anonymous — Tue, 01 Mar 2016 03:00:16 GMT

Hi,

how do I omit a row from showing up in my grid using the Expression function (i.e. I don't want to do it I the SQL script load)?

So my data looks like below. I don't want products to be included if the Prodtypecode is 200021. I have tried many ways but cant get it to work? I have a filter that says IsMember = 'Yes' and that works fine so I don't understand why this wont work. Any help appreciated.

Re: omit record in the expression

tamilarasu — Tue, 01 Mar 2016 03:07:32 GMT

You can try something like below.

You can also use Aggr function instead of "If" statement in calculated dimension.

=Aggr(only({<ProdTypeCode-={'200021'}>} ProdTypeCode),ProdTypeCode)

Re: omit record in the expression

Tue, 01 Mar 2016 03:12:14 GMT

You can use calculated Dimension or add the filter on the set expression like below ways:

IF( ProdTypeCode <> 20021,ProdTypeCode) and select "Supress Value is Null"

Sum({<ProdTypeCode-={20021}>} Value) --> you can use set expression in your expression to avoid the 20021 ProdTypeCode and relatively its speed when compare to Calculated Dimension.