Discussion board where members can get started with QlikView.
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 :
Date(Date#(SubField( FileName(),'.',1),'YYYYMMDD'),'DD/MM/YYYY') as Date
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
STORE SOURCE_DATA INTO ..\QVD\SOURCE_DATA.QVD;
DROP TABLE SOURCE_DATA;
Date(MakeDate(Tahun,Bulan,Tanggal),'DD/MM/YYYY') as Date
(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 :
And this is what it should be :
Where did I do it wrong ? Does it in QVD or the script in QVW ?
Great ! It works, thank you so much
Glad to help you
It's already solved, and also the dummy files already attached in the previous comment