topic Re: Script query: And year in QlikView

Script query: And year

knightwriter — Fri, 19 Feb 2016 13:41:06 GMT

Hi all,

I want to make an additional query in my script to only include certain this year and last year only. What am I doing wrong?

LOAD *,

if(isnull([Opportunity]),'NO ',[Opportunity]) AS [Opportunity inc Nulls]

FROM [\\$(oEnvironment)\Qlikview\QVDs\Opportunity.qvd] (qvd)

Where ([Opportunity Anticipated Year] >= (Year(Today()) - 1));

Re: Script query: And year

pooja_sn — Fri, 19 Feb 2016 13:45:55 GMT

Above query looks good.Is there any error message you are getting ?

Re: Script query: And year

sunny_talwar — Fri, 19 Feb 2016 13:56:12 GMT

Looks right, the only thing I would check is if [Opportunity Anticipated Year] is text or number? What is the exact error that you see when you load the above script?

Re: Script query: And year

knightwriter — Fri, 19 Feb 2016 14:29:09 GMT

Thanks, I created a master calendar with that field name and I believe it couldnt pick it up. I changed it to Add Year and seemed to work ok.

Re: Script query: And year

Colin-Albert — Fri, 19 Feb 2016 14:31:08 GMT

Check the data in Opportunity Anticipated Year, is it YYYY or YY and is it the same format as "Year(Today()) -1"