-
Re: Qlik Sense 30 Day calculation ignoring date filters
pavan kumar Feb 8, 2018 11:49 AM (in response to Toby Cameron)You may try
1.use above() [for previous 30 days values ]instead of below() if you need more clarity look at this post
Missing Manual - Above() and Below()
2.and also try aggr() on top of sum() [ RangeSum(Below total (Aggr(Sum())) ]
RangeSum( Below (total Aggr(Sum(FLIGHT),FLIGHT_KEY)),0,30)
-
Re: Qlik Sense 30 Day calculation ignoring date filters
Toby Cameron Feb 13, 2018 12:18 AM (in response to pavan kumar)1. The data was structured such that below was the best case. as the table was sorted that way. This is because I was doing it in the visualisation layer.
2. This results in the value 30 being placed for every record.
-
-
Re: Qlik Sense 30 Day calculation ignoring date filters
Andrea Gigliotti Feb 8, 2018 3:39 AM (in response to Toby Cameron)would do you have a simple app with mock data to look at ?
-
Re: Qlik Sense 30 Day calculation ignoring date filters
Sunny Talwar Feb 8, 2018 8:35 AM (in response to Toby Cameron)May be this
RangeSum(Below(Sum({<Month>}Aggr(Only({<Month>}FLIGHT), FLIGHT_KEY)), 0, 30)) * Avg(1)
-
Re: Qlik Sense 30 Day calculation ignoring date filters
Toby Cameron Feb 13, 2018 12:19 AM (in response to Sunny Talwar )I changed the <Month> fields to the <FACT_DATE> fields i was using for individual dates and it seems to work, thank you.
-