Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to load an excel in qvd form?

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.

13 Replies
Anonymous
Not applicable
Author

initially when you load data from different sources like excel,database and store it into qvd. this is called extraction layer.

then you perform transformation (in another application and store it in qvd)in which you load the qvd created in extraction layer. - this layer is called transformation layer.

and then you use this transformed qvd for creating your dashboard

Anil_Babu_Samineni

In detail with one formation.

Qlik.jpg

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Awesome!! Thanks

Anonymous
Not applicable
Author

Thanks