Discussion board where members can get started with Qlik Sense.
I have a table in qlik, and I would like to add a new column in the data load
The data that have a data 2017 are fine, but I would increment 1 year more for the data that contain 2016 as in the example below:
Sales Data DataUpd
100 02.02.2017 02.02.2017
230 04.02.2016 04.02.2017
234 06.06.2016 06.06.2017
565 08.08.2017 08.08.2017
All the info are in a table called sales...
Some idea about?
Thanks a lot
Go to Solution.
you can use the below in script editor:
if( Year(Data) = 2016, AddYears(Data, 1), Data ) as DataUpd;