Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rmdnkevin
Contributor III
Contributor III

Create QVD File from Multiple Files

Hi, everyone.

I have some files named 20180612, 20180704, 20180808 and etc in csv format and also reportedTicket in xlsx format.

I need to create QVD from those files, I'm trying to create QVD from this script :

Create QVD

SOURCE_DATA:

LOAD

     email,

     first_name,

     last_name,

     position,

     status,

Date(Date#(SubField( FileName(),'.',1),'YYYYMMDD'),'DD/MM/YYYY') as Date

FROM

..\SOURCE\20******.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE SOURCE_DATA INTO ..\QVD\SOURCE_DATA.QVD;

DROP TABLE SOURCE_DATA;

JUMLAH_REPORT:

LOAD Tahun,

     Bulan,

     Tanggal,

     [Jumlah Report],

     Date(MakeDate(Tahun,Bulan,Tanggal),'DD/MM/YYYY') as Date

FROM

..\SOURCE\reportedTicket.xlsx

(ooxml, embedded labels);

STORE JUMLAH_REPORT INTO ..\QVD\JUMLAH_REPORT.QVD;

DROP TABLE JUMLAH_REPORT;

It works, but, when I put in QVW file, it only shows a single chart like this for the SOURCE_DATA.qvd :

Screenshot_3.png

And this is what it should be :

2.png

Where did I do it wrong ? Does it in QVD or the script in QVW ?

Thank you.

- Kevin

12 Replies
rmdnkevin
Contributor III
Contributor III
Author

Great ! It works, thank you so much

qlikviewwizard
Master II
Master II

Glad to help you

rmdnkevin
Contributor III
Contributor III
Author

It's already solved, and also the dummy files already attached in the previous comment