Hi All,
I have done max of week to view the new users count as of a week. But the issue is, If i select the week filter and select 3 weeks. i would like to view all the 3 weeks count. But i am getting only Max of week, because as we are doing WTD, it takes only 7 days.
But, i would like to view first 7 days and then by selecting filters i would like to view 14 days count or 21 days counts.
Is this possible in Qlik and the expression i am using is count({< WEEK={"$(=Max(WEEK))"}> }[NewUsers]).
My data is :
WEEK | NEW USERS COUNT |
4/14/2019 | 3 |
4/07/2019 | 3 |
03/31/2019 | 4 |
I a KPI i would like to view the Max of week which is of 4/14/2019 and if i select filter of 4/14 and 4/17 the count should be 6.
Please do let me know either it is possible or not.
