Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone.
I have the following question.
The following formula (of a graph) works and, when I make some selection in the Dashboard, it filters correctly.
SUM({1<[Date]={">=$(=YearStart(min(Date))) <=$(=YearEnd(max(Date)))" }>}[amount_1])
But, the next formula I need to apply for a metric (of a graph) with aggr and distinc, does not filter correctly. If I make a selection, the formula does not filter according to that selection. The formula is this:
SUM(aggr(SUM(DISTINCT {1<[Date]={">=$(=YearStart(min(Date))) <=$(=YearEnd(max(Date)))" }>}amount_2), id_center))
How should this second formula be expressed correctly so that it filters?
Thank you very much.
Greetings.
Hi,
There is some detail on the blog here;
Set Analysis in the Aggr function - Qlik Community - 1463822
This suggests putting set on both aggregations (so both SUM statements), with caveats on testing & how to work out if inner/outer/both is actually the right thing to do.
Cheers,
Chris.