Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshraj
Partner - Creator
Partner - Creator

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
MVP
MVP

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
Partner - Specialist III
Partner - Specialist III

Hi Dineshraj,

Aggr is  used for group by purpose.

Thanks,

Arvind Patil

rahulpawarb
Specialist III
Specialist III

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
Partner - Creator
Partner - Creator
Author

Hi Chanty,

Can you explain with an Example