Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ol00681110
Contributor
Contributor

Weekly filter display is different from actual date

Hi,

I have a chart that is showing data for the last 2 months which is Nov and Oct 2022.

When I click on the filter to filter our data by week, the drop down list only provide the option to select weekly data from year 2019 and 2020.

What should I do to show the weekly data for 2022 which is the current year instead of showing weekly data for the past years?

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

you can add a calculated dimension for the Week filter as below, but this will be slower

replace  

=WEEK

with

=aggr(only({<YEAR={"=Max(YEAR)"}>}WEEK),WEEK)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.