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

vikasshana — Thu, 21 Oct 2021 14:35:29 GMT

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?

topic How to restrict data to load until current week from date field in QlikView

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