Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aamaninanneboin
Contributor
Contributor

By doing WTD, data should be visible with rest of the weeks by selecting filters.

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.

 

0 Replies