Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to limit rows in table by Measure amount

I have a plain table with number of calculations around sum(Amount) grouped by different time period, so basically it's plan table, how I can show only rows where let say  sum(Amount) > 0  (I still have records with 0 o negative amount),  I can't eliminate them on data load step.

I don't see any filters neither on Dim or Measures,   thanks for help.

Vic

1 Solution

Accepted Solutions

Re: How to limit rows in table by Measure amount

Hi Viktor, maybe you can create a calculated dimension that only shows values wich meet the criteria, like:

Aggr(If(Sum(Sales)>0, Customer), Customer) // It will list only customers with Sales>0

5 Replies

Re: How to limit rows in table by Measure amount

Hi Viktor, maybe you can create a calculated dimension that only shows values wich meet the criteria, like:

Aggr(If(Sum(Sales)>0, Customer), Customer) // It will list only customers with Sales>0

Not applicable

Re: How to limit rows in table by Measure amount

Thanks much Ruben,

It worked OK, I create this cond dim (I assume it's just conventional Dim with function in def), and then after uncheck <remove NULL> that raw gone!

I'm bit still confused with tranlation of this f:


Aggr(

         if(Sum(Sales)>0, Customer), Customer  // if sum(Sales) > 0 then dim on Customer, if not then still Customer ??

        )

Thanks much again.

V

vinieme12
Esteemed Contributor II

Re: How to limit rows in table by Measure amount

The AGGR function will check for each Customer if sum(sales) >0 and return Customer if true , else null().

Not applicable

Re: How to limit rows in table by Measure amount

Thanks Vineeth!

And  I see that after that you need to uncheck <Show null values>, at least for my case as I have some joins.

vinieme12
Esteemed Contributor II

Re: How to limit rows in table by Measure amount

correct

and you need to Check "Suppress when value is null" on the dimension

Community Browser