Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am just a week into Qlikview so don't have that in depth knowledge.
But have recently come up with something.
I am creating this basic qlikview application where i am reading data from two databases
1) Salary
2)Quarter
I am able to read data from my salary excel sheet whereas i created a qvd file from my quarters excel sheet and loaded both of them.
But after loading i cannot find any data or fields from the Qvd file whereas Salary sheet is working fine.
Is there any line of code i have to add for the qvd file to work. I have attached the QVW and the excel sheets.
Kindly assist,
Regards,
Rahul
ps: Both the tables are not related by any means and are for practice purpose.
Hi Rahul,
Check attachment.
Also for reading as qvd do like below and read this table as qvd
Quarters:
LOAD Month,
Quarter,
Sales,
Target
FROM
C:\Users\asaini\Desktop\Quarters.xlsx
(ooxml, embedded labels, table is Q_1);
Store Quarters into give_Path\Quarters.qvd;
Drop table Quarters;
Thanks,
AS
Hi
PFA and check on your system.
Regards
QlikView file as well.
Hi Rahul,
Check attachment.
Also for reading as qvd do like below and read this table as qvd
Quarters:
LOAD Month,
Quarter,
Sales,
Target
FROM
C:\Users\asaini\Desktop\Quarters.xlsx
(ooxml, embedded labels, table is Q_1);
Store Quarters into give_Path\Quarters.qvd;
Drop table Quarters;
Thanks,
AS
Hey Sumita,
Thanks for your wonderful reply and the code is working fine now.
As am a newbie and this being my learning curve, please let me know any reason why it wasn't working in the first place. Was there any additions from your end.
Did I miss something while loading data.
Thanks again
Regards,
Rahul
Hey Amit,
Thanks for your reply.
A few things I would like to know like first time when I tried with Qvd alone it didnt funtion but when I loaded the xls sheet it did respond so any reason it happened that way or was there a fault from my side.
I am getting a bit confused in knowing the way a Qvd works.
Thanks again for your helping hand.
Regards,
Rahul
Rahul,
First you need to call data from source file , in your case it is Excel sheet. After loading this excel convert this data into QVD file and now instead of calling excel you can call this qvd for your purpose.
Thanks,
AS
Also please check this link -> How you can load a QVD into your application.
http://community.qlik.com/message/680130#680130
Thanks,
AS
Hi Amit,
I just gave a try to the binary load but after removing the QVD code and then while loading it is showing an error saying
I have assured the Binary load line is the very first line of the main.
It is giving the same error also with the qvd code included.
Is it that it (binary load) works predominantly with QVW files only or is it any thing else.
Thanks and regards,
Rahul
Looks like your qvd is in some other format make it default as QlikView file. Yes Binary will work with QVW only.
Thanks,
AS