Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

change dates

 i want to change dates with another dates in script 

like 

if i have 

loss date   new date

01/01/2019    02/03/2019

02/02/2019   03/02/2019

 

how i do this ?

 

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

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.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Simply use Mapping.

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

When needed use ApplyMap to change dates.

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.