Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am going through an expression.I find it difficult to understand the below expression.
Can anyone explain about this?
Thanks in advance
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
Aggr is used for group by purpose.
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.
Can you explain with an Example