Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

The table display more then 100 row. I want to display those sales amount > 1000.

HI All

I have a table which display

Dimension :-

COMPANY

date

Expression :-

Sum(if(Month_n='1',sales))/Rate

The table display more then 100 row.  I want to display those sales amount > 1000.

May i know how to do it ?

Paul Yeo

1 Solution

Accepted Solutions
kaanerisen
Contributor III

Re: The table display more then 100 row. I want to display those sales amount > 1000.

Hi,

You can use this expression

sum(aggr(IF(Sum(if(Month_n='1',sales))/Rate>1000,Sum(if(Month_n='1',sales))/Rate),COMPANY,date))

and uncheck "Include zero velues" on Data handling menu of table properties.

Hope it helps.

3 Replies
paulyeo11
Valued Contributor II

Re: The table display more then 100 row. I want to display those sales amount > 1000.

My QVF !

kaanerisen
Contributor III

Re: The table display more then 100 row. I want to display those sales amount > 1000.

Hi,

You can use this expression

sum(aggr(IF(Sum(if(Month_n='1',sales))/Rate>1000,Sum(if(Month_n='1',sales))/Rate),COMPANY,date))

and uncheck "Include zero velues" on Data handling menu of table properties.

Hope it helps.

paulyeo11
Valued Contributor II

Re: The table display more then 100 row. I want to display those sales amount > 1000.

Apprecaite very much it work

Community Browser