Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
dineshraj
Not applicable

If Statement without condition

Hi Experts,

        I am going through an expression.I find it difficult to understand the below expression.

aggr(if(Sum(Amount),Sum(Amount)),FiscalMonth)

Can anyone explain about this?

Thanks in advance

4 Replies
Chanty4u
Not applicable

Re: If Statement without condition

it is :

if the sum of amount is 100 it will display 100 based on fiscal month

aggr will be used over the dimension to caluclate

arvind_patil
Not applicable

Re: If Statement without condition

Hi Dineshraj,

Aggr is  used for group by purpose.

Thanks,

Arvind Patil

rahulpawarb
Not applicable

Re: If Statement without condition

In above straight table, AGGR expression will create a logical table with columns - FiscalMonth & Sum(Amount).

It will display these two columns if respective FiscalMonth has Sum(Amount) > 0.

Input:

   

DateFiscalMonthAmount
01/01/201791,000
01/10/201792,000
04/04/201715,000
04/05/201714,000
06/04/201735,000
06/05/20173-5,000

Output:  

FiscalMonthaggr(if(Sum(Amount),Sum(Amount)),FiscalMonth)
19000
93000

Regards!

Rahul Pawar

dineshraj
Not applicable

Re: If Statement without condition

Hi Chanty,

Can you explain with an Example