topic Re: Qvd Records in QlikView

Qvd Records

Tue, 04 Nov 2014 11:11:31 GMT

Hi i have a qvd ... witch containes the date and cusid fileds, in that i has the 3 months of data ..... how to find each month records indiviually

please let me know the answer

Peter_Cammaert — Tue, 04 Nov 2014 11:23:14 GMT

Load all data from your QVD, and create a new Month-column based on the date field. That column will show you the month of each record.

Data:

LOAD *, Month(DateField) AS Month

FROM YourFile.qvd (qvd);

If you want to load a single month, add a WHERE clause to your LOAD statement, like in

SET vMonth = 2; // February

Data2:

LOAD *

FROM YourFile.qvd (qvd)

WHERE Month(DateField) = $(vMonth);;

Tue, 04 Nov 2014 11:29:02 GMT

Or like this

For i = 1 to 12

SET vMonth = $(i); // February

DataMonth_$(i):

LOAD *

FROM YourFile.qvd (qvd)

WHERE Month(DateField) = $(i);

Store DataMonth_$(i) Into DataMonth_$(i).qvd (QVD);

Tue, 04 Nov 2014 12:30:33 GMT

Hi i wanna only 3 months data ... to count .... please tell me the way ....

my filed containes data of 3 months exp 1, 2,3 months of date

so what is the way to count for each and every month indiviually

Peter_Cammaert — Tue, 04 Nov 2014 13:37:22 GMT

Use a LOAD with a GROUP BY clause, and add Month to the grouping.

Now you can count, sum, average etc. all other numeric fields in your file and this time per month.