-
Re: QlikSense Default Month Filter
Nicole Smith Sep 6, 2016 12:41 PM (in response to Azmina Virani)What about something like this?
if(GetSelectedCount(Month)=0,
Aggr(Rangesum(above(TOTAL(SUM ({<Month = {$(=Month( AddMonths(Today(),-1)) )} , [MonthYear] =,
WeekDay=>} [Net Load])), 0, RowNo())), (Year, (NUMERIC)), (Day, (NUMERIC))),
Aggr(Rangesum(above(TOTAL(SUM ({<[MonthYear] =, WeekDay=>} [Net Load])), 0, RowNo())), (Year, (NUMERIC)),
(Day, (NUMERIC)))
)
It will use the last month calculation when the user doesn't have any month selected, but if they select one or more months, it will use those instead.
If it was in QlikView, I would have two expressions and use GetSelectedCount() calculations as conditions to enable each function when necessary. As far as I can tell (I don't have experience with QlikSense), you don't have the ability to do the same thing in Sense (please let me know if I'm incorrect here).
-
Re: QlikSense Default Month Filter
Azmina Virani Sep 6, 2016 1:07 PM (in response to Nicole Smith )You are AWESOME! Thanks Nicole :-)
-
Re: QlikSense Default Month Filter
Azmina Virani Sep 6, 2016 1:10 PM (in response to Azmina Virani)and you are write, there isn't a way to add another expression to the same chart, unless you want to add it as an alternative expression.
-
-