Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sanket_Sharma
Partner - Contributor III
Partner - Contributor III

Not able to use Max Week script with Max year filter simulataneously

I have created a dashboard which shows  max_week data by default but when I select max year in year filter it shows the same data of max week instead of max year . Even when I select max date range upto max year in calendar it is not working. I have used this script to show max week data.

 sum({$<week1 = {$(=Max(week1))}> } count_IEC_NEW_IECs_REGISTERED)

Help me so I can use max year and max week  simultaneously working .

 

 

1 Solution

Accepted Solutions
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

try nullifying the filter in set expressions

Thanks

Thanks and Regards
Kashyap.R

View solution in original post

3 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

try nullifying the filter in set expressions

Thanks

Thanks and Regards
Kashyap.R
Sanket_Sharma
Partner - Contributor III
Partner - Contributor III
Author

Can I use it on dimension? Because I am using year as a dimension in filter. If Yes, then how?

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi 

I am not sure about that try going through the only function.

Thanks

Thanks and Regards
Kashyap.R