How to load an excel in qvd form?

[Anonymous]

Hi,

I used the store tablename into tablename.qvd statement and the script executed successfully, but now I want to load the qvd instead of the excel and computed columns (some calculations on) that I did while loading excel. How to do that?

Thanks.

[Anil_Babu_Samineni]

You need to drop the excel table and reload the QVD like https://www.analyticsvidhya.com/blog/2014/08/qvds-qlikview-application-efficient/

[Anonymous]

Now load the qvd which you have created and perform transformation

[techvarun]

TEST:
LOAD QTY, 
     Name, 
     Sales,
     ID* sales as Actual
FROM
Test.xlsx
(ooxml, embedded labels, table is Sheet1);




STORE TEST into ACTUAL.qvd;


Drop table TEST;


ActualData:
LOAD *
FROM
ACTUAL.qvd
(qvd);

You mean this?

[Anonymous]

ok, but I've already created a good dashboard with the excel , so do I need to create the dashboard again after I load the qvd??

[Anil_Babu_Samineni]

Don't required. Simply reload then your visualization won't change because of data already stored in memory ..

[Anonymous]

Ok thanks, and this will reduce the reload time right? due to qvd 90% compression??

[Anil_Babu_Samineni]

Very high chances are there to get into optimized one. You will analyze more which needed to understand.

Note - You can mark correct answer for one solution which gave 100% accuracy and make it as other responses like helpful ..

[Anonymous]

just select all the objects from your already created dashboard and paste it in the qvd one.

Generally we don't create dashboard in extraction layer

[Anonymous]

Ok, can you please explain what you mean by extraction layer?