Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Simply use Mapping.
Create mapping table with two columns old date and new date.
When needed use ApplyMap to change dates.
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