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: 
smilingjohn
Specialist
Specialist

year

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

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

or try this

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

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

View solution in original post

6 Replies
chinnuchinni
Creator III
Creator III

field name should be start with char.

you can rename it as      year2         and      Year1

Chanty4u
MVP
MVP

or try this

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

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

suren946
Contributor III
Contributor III

This works

Temp:

Load

Date,

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

year(Date)-1  as '1Year'

From xyz.xls

Chanty4u
MVP
MVP

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Chanty4u
MVP
MVP

for me its giving error with same code

version 12