topic Re: In my report contain Last three months data only. in QlikView

In my report contain Last three months data only.

Srinivas — Tue, 14 Oct 2014 08:41:00 GMT

Dear All,

In my report contain Last three months data only.

Presuppose current month data will be updating every day but last two (AUG, SEP) Months qvds data not updating every day why means it was already created(Those were constant).

After completion of this month then my script will extract November month data then my report Contain last three month means SEP, OCT, NOV only Now here November month qvd will be every day updating.

This is my scenario how we can write the code. Could you please send to me any sample applications.

Advance Thanks,

Munna

Re: In my report contain Last three months data only.

ogster1974 — Tue, 14 Oct 2014 09:10:30 GMT

http://www.qlikcommunity.com/thread/60558

HI Munna

You can restrict the data in your query to only return the last 3 months if that is your requirement and you are allowed to change the data query. in SQL you would use the DATEADD(M,-3,<YourDate>) Function for example:

If not bring the data into Qlik with the date condition applied on load.

The above thread should help get you started on date filters in Qlik.

Re: In my report contain Last three months data only.

Tue, 14 Oct 2014 09:17:03 GMT

Hi,

if you have QVD (Data.QVD) storing 3 months data Aug,Sep,Oct then write the script like this.

Data:

//from QVD

Load * from Dat.qvd(qvd)

where match(Month,Month(AddMonths(today(),-1)),Month(AddMonths(today(),-2)));

//Current month data from database

Load *

sql

select * from table where month=month(getday())

where match(Month,Month(AddMonths(today(),-1)),Month(AddMonths(today(),-2)));

store Data into Data.QVD(qvd);

drop table Data;

Re: In my report contain Last three months data only.

Gysbert_Wassenaar — Tue, 14 Oct 2014 09:17:36 GMT

See this document: Loading Multiple QVD files