topic Re: last three years data.01-Apr-2013 in QlikView

last three years data.01-Apr-2013

prma7799 — Thu, 02 Jul 2015 04:54:21 GMT

Hi All,

In my current application there have data from 01-Apr-2008 from till date.

Now my data become big every day and it is impacting our application day by day.

Now I want take only limited data say from 01-Apr-2013 to till date.

I want my financial year from 01-apr-2013 and fiscal year for 2013,2014,2015,2016

PFA script for callendar.

Re: last three years data.01-Apr-2013

prma7799 — Thu, 02 Jul 2015 05:31:38 GMT

Anyone can give some idea on this?

Re: last three years data.01-Apr-2013

Siva_Sankar — Thu, 02 Jul 2015 05:33:53 GMT

You either change the value of VarMindate or Varmaxdate according to your requirements. or limit the data in the transaction table or in the fact table.

Ex:

Load * from your table

where Fiscal Year >='2013'

and financial date>='01-APR-2013';

Re: last three years data.01-Apr-2013

jagan — Thu, 02 Jul 2015 05:49:55 GMT

Hi,

Try like this

where TempDate>= YearStart(Today(), -2, 4) -- This will give 1-Apr-2013

and TempDate<=MakeDate(Year(today()),1,1)

ORDER BY TempDate Asc;

Regards,
jagan.

Re: last three years data.01-Apr-2013

pratap6699 — Thu, 02 Jul 2015 07:49:27 GMT

Load * from your table

where Fiscal Year >='2013'