Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
GURRAMVEN
Contributor
Contributor

Date Restriction

I have Date field like this "CREATEDDATE_WW" This filed has to be restricted  to last 6 weeks from the current week . suppose if i move to next week i have to get the data for last 5 weeks.

 

Labels (1)
1 Reply
Wlad_Masi
Employee
Employee

@GURRAMVEN 

You can create a rule in your load script, using Today() function, so every time you reload is will refresh for the "new" las 6 weeks.
In this post Displaying last week's data you can see how to load data for the previous week, the same logic can be used to load date for 6 weeks back.
I would also check this other post Only load data of last 4 weeks, that is not marked as solved but have good ideas on this topic.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.