Update table in qlik sense

[pascos88]

Hi,

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

[agigliotti · Accepted solution]

you can use the below in script editor:

if( Year(Data) = 2016, AddYears(Data, 1), Data ) as DataUpd;