Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date field for January, February and March 2019 and would like to replace it with the current date, for example in November 2022, December 2022 and January 2023.
I would be grateful for any suggestion
Can you give more details?
Not sure if that's what you need but you can literally add a number to the date like...
date( [Jan_2019] + 365)
Or maybe you are after the 'Today()' function.
today - script and chart function | Qlik Sense on Windows Help
Hi,
Please see the table for the desired result, and would like to keep the actual date updated
Date |
Current Date |
3/30/2019 |
1/26/2023 |
3/29/2019 |
1/25/2023 |
3/28/2019 |
1/24/2023 |
…. |
…. |
…. |
…. |
3/1/2019 |
12/28/2022 |
2/28/2019 |
12/27/2022 |
…. |
….. |
2/1/2019 |
11/30/2022 |
…. |
….. |
1/31/2019 |
11/29/2022 |
…. |
…… |
1/1/2019 |
10/30/2022 |
e.g Show the table the next day
Date | Current Date |
3/30/2019 | 1/27/2023 |
and the day after tomorrow the table should look like this
Date | Current Date |
3/30/2019 |
1/28/2023 |
3/29/2019 |
1/27/2023 |
3/28/2019 |
1/26/2023 |
....... |
....... |
and so on ....
HI,
Try below
Create a variable to calculate number of days.
vDays=today()-Max(Date)
Expression:
Date(Date+vDays)
Thanks,
Sasi