topic Re: Script prob in QlikView

Script prob

nikhilgarg — Tue, 04 Aug 2015 11:27:38 GMT

Hey,

I have a doubt that:

I am writing script where i ahve to fetch data for current fiscal year only as:

Table1:

Load a,

b,c from def.qvd(qvd) where TRANS_DATE >= if(num(month(Today())) < 11 , (year(Today()) - 1)-11-01 , year(today()-11-01)) and

TRANS_DATE <=today();

does my script after where clause is correct ?

jonathandienst — Tue, 04 Aug 2015 11:31:40 GMT

Use the Fiscal offset in YearStart:

Where TRANS_DATE >= YearStart(Today(), 0, 11) And TRANS_DATE <= Today()

Gysbert_Wassenaar — Tue, 04 Aug 2015 11:32:01 GMT

(year(Today()) - 1)-11-01 = 2014-11-01 = 2014-12 = 2002 = the 26th of june 1905.

sunny_talwar — Tue, 04 Aug 2015 11:34:04 GMT

1) (year(Today()) - 1)-11-01

2) year(today()-11-01))

Everything looks good, but what exactly you are trying to do with these two above??