How i can insert Date field Column in Qlik sense Load Script
HI,
I want to Load next Sunday As my Date field.
Eg: Today is Tuesday i.e 26/11/2019 and i want my date should be 1/12/2019, It should automatically load the next Sunday of the Coming Week, and should load for all the records
Can anyone help me how to do this as i am new to Qlik.
Note:There is no Date, Month,Year fields in my Data.
You can add the following as a field to your load script.
Date(Floor(Weekend(Now(1),0,0)),'DD/MM/YYYY') AS Date
The date will always be the first Sunday after the data load is triggered. It will be 1/12/2019 for this whole week and change to 8/12/2019 when the data is loaded again after Sunday. You can have a look at different now functions.
Or do you want this date to change automatically when the user opens the app in the next week?
You can add the following as a field to your load script.
Date(Floor(Weekend(Now(1),0,0)),'DD/MM/YYYY') AS Date
The date will always be the first Sunday after the data load is triggered. It will be 1/12/2019 for this whole week and change to 8/12/2019 when the data is loaded again after Sunday. You can have a look at different now functions.
Or do you want this date to change automatically when the user opens the app in the next week?
Now my date field is 1/12/2019 and yes, I want this date to change automatically when the user opens the app in the next week.(is this possible when i am using Live data??)
And also i want to add even the Week based on the date filed. Week should start from Monday to Sunday as i want to generate my report on Monday for the upcoming Week i.e That week Monday to Sunday.
What is the use case for having this date available dynamically? Also, I am not sure what exactly you want with the week. Is it just the current week number? If so, I suggest that you look at the week and weekname functions.
