topic Re: pulling sql's one month data in qlikview in QlikView

pulling sql's one month data in qlikview

Fri, 20 Nov 2020 18:02:30 GMT

Hi Experts,

i have a sql table which has 2015 whole data.

from this table, i want to load monthly datas in qlikview and store in qvd.

Sql date format is like 'YYYY-MM-DD'

How can i do this.

Please help.

Gysbert_Wassenaar — Fri, 05 Feb 2016 15:33:32 GMT

Perhaps like this:

Temp:

LOAD *, Month(MyDate) as Month

SQL Select * From My2015Table;

For i=1 to 12

MonthlyData:

Load * Resident Temp Where num(Month) = $(i);

Store MonthlyDate into MonthlyData2015_$(i);

Drop Table MonthlyData;

sathishkumar_go — Fri, 05 Feb 2016 15:39:11 GMT

Hi,

1) load the distinct date field

2) create one variable to get the no of rows in the table

3) use for loop

4) in for loop to pass the query and use the where condition to load only particular month data only

5) create a qvd. qvd name should be QVDNAME_MONTH

------------------------------------------

Temp:
LOAD DISTINCT
Date AS Date_Temp
FROM
query;

LET v_nr_folders = NoOfRows('Temp');

FOR i=0 to $(v_nr_folders)-1

LET v_Date = Peek('Date_Temp',$(i),'Temp');

QUERY
SQL SELECT *
FROM TABLE NAME WHERE Date = '$(v_Date)';

STORE TableName into Path\$(v_File_Name).qvd;

drop table TableName;