topic change dates in QlikView

change dates

capriconuser — Wed, 25 Nov 2020 16:16:04 GMT

i want to change dates with another dates in script

if i have

loss date new date

01/01/2019 02/03/2019

02/02/2019 03/02/2019

how i do this ?

Re: change dates

dplr-rn — Wed, 15 Jan 2020 15:05:22 GMT

need more details for us to help.

how are you calculating the new data? where does it come from? whats the original table look like etc.

Re: change dates

MindaugasBacius — Thu, 16 Jan 2020 07:47:42 GMT

Simply use Mapping.

Create mapping table with two columns old date and new date.

When needed use ApplyMap to change dates.

Re: change dates

Brett_Bleess — Wed, 12 Feb 2020 21:17:13 GMT

Just adding a Design Blog post that aligns with the last poster:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

If one of the posts did help you, do not forget to come back to thread and use the Accept as Solution button. I see you guys posting quite a bit and you often leave things unmarked, it would be greatly appreciated if you would be more diligent about marking the solutions instead of leaving them open.

Regards,
Brett