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

How to restrict data to load until current week from date field

Hi,

I've a date field in my application which has the dates from 1/1/2019 till 12/31/2021. Now if I create a Week(Datefield) the week number will be from 1 to 53. 

So my requirement is if user selects year 2019 Week numbers has to be from 1 to 53, if User selects year 2020 Week numbers has to be from 1 to 53 and if User selects year 2021 Week numbers has to be from 1 to 43 where it has to restrict to load until Week 43 for current year and next week it has to load data until Week 44 because next week number is 44.

Any idea how to achieve it?

 

0 Replies