Hello. I try to write if statement in load part of the script. I have "sale date" in format YYYY-MM-DD hh:mm:ss. I need to add column with value that depends on year.
According to qlik sense help i've written in load that line:
if(Date("sale date",'YYYY')=2011,'CY','LY') as newfield,
but it shows only LY when year is 2011,2010 and in the rest of years there is '-'
so it makes me a little confused what to do with it.
Thanks in advance very much.