topic Re: year in QlikView

year

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

Hi All,

In the script iam using the below syntax to get required output , but when i reload it is giving me an error ..

can someone please suggest

year(Date)-2 as 2year,

year(Date)-1 as 1year,

Thanks in Advance

chinnuchinni — Mon, 02 Apr 2018 09:09:35 GMT

field name should be start with char.

you can rename it as year2 and Year1

Chanty4u — Mon, 02 Apr 2018 09:11:01 GMT

or try this

year(Date)-2 as "2year",

year(Date)-1 as "1year",

suren946 — Mon, 02 Apr 2018 10:07:38 GMT

This works

Temp:

Load

Date,

year(Date)-2 as '2Year',

year(Date)-1 as '1Year'

From xyz.xls

Chanty4u — Mon, 02 Apr 2018 10:09:14 GMT

nice please close the thread by making correct and helpfull answers above.

Anil_Babu_Samineni — Mon, 02 Apr 2018 12:55:45 GMT

Curious to know, I am running Reload() without any error

Chanty4u — Mon, 02 Apr 2018 12:57:57 GMT

for me its giving error with same code

version 12