Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I built a variable for calendar day: [Calendar Day]=Date(Today()-1)
This variable is part of a bookmark. Now I need a formula which regardless of the bookmark (today-1 day) calculates a KPI over all days and not only the previous day.
Instead of the filter bookmark value '-1', I used '0'. But this formula is not working:
avg(aggr(Sum({<"=[Calendar Day]=Date(Today()-1)"={'0'}>} Amount), [Calendar Day]))
Any ideas?
Thanks, Tom
I solved it via this blog: https://community.qlik.com/t5/New-to-Qlik-Sense/help-with-AVG-AGGR-Count-Set-Analysis-and-ignoring-a...
Correct formula on my side:
avg({<Calendar Day>} aggr(Sum({<[Product Unit]={'Cars'}, Calendar Day=>} Amount), [Calendar Day]))
Hi, maybe just remove date filtering? Leave expression something like this:
avg(aggr(Sum(Amount), [Calendar Day]))
I solved it via this blog: https://community.qlik.com/t5/New-to-Qlik-Sense/help-with-AVG-AGGR-Count-Set-Analysis-and-ignoring-a...
Correct formula on my side:
avg({<Calendar Day>} aggr(Sum({<[Product Unit]={'Cars'}, Calendar Day=>} Amount), [Calendar Day]))