topic Re: last one year data in QlikView

last one year data

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i want to load last one year data while loading to QVD from DB

i have a Month Field

CreatedMonth

201804

201805

201806 like that

and i have a Quarter filed like below

2018Q1

2018Q2 like so on...

Thanks

Sony

Re: last one year data

Anil_Babu_Samineni — Thu, 09 Aug 2018 09:15:22 GMT

Use this?

Table:

Load * From Table;

Store Table into ../../Store.qvd (qvd) Where Year = Year(Today());

Re: last one year data

tamilarasu — Thu, 09 Aug 2018 09:16:18 GMT

Hi Sony,

Do you want to load the data from 201708 to till date? If so, try

Let vVar = Date(Monthend(AddMonths(Today(),-12)),'YYYYMM'); //201708

Data:

Load *

From

DB Path where CreatedMonth >= $(vVar);

Re: last one year data

soniasweety — Thu, 09 Aug 2018 09:21:41 GMT

yes

i want the till date to last year same day(or same quarter) so how can i do this?

Re: last one year data

tamilarasu — Thu, 09 Aug 2018 09:23:39 GMT

If you want to load the data to last year same day, you need a date field.

Re: last one year data

soniasweety — Thu, 09 Aug 2018 09:25:54 GMT

i have date field created

in this format MM/DD/YYYY

Re: last one year data

tamilarasu — Thu, 09 Aug 2018 09:30:06 GMT

You can alter the above script.

Let vVar = Date(AddMonths(Today(),-12),'MM/DD/YYYY'); //08/09/2017

Data:

Load *

From

DB Path Where Created >= '$(vVar)';

Re: last one year data

vishalarote — Thu, 09 Aug 2018 10:20:55 GMT

PFB the Solution Hope so it will help you.

Data:

Load *

From

DB Path

where Date>=Daystart(today(),-365) and Date<=Today();