Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sachinjoshilkar
Contributor II
Contributor II

From QVDs can we create Excel sheets?

We have created QVDs by importing excel and data from other sources such as MS access. Can we export those QVDs back to excel after collating all the data sheets ?

Thanks,

Sachin

1 Solution

Accepted Solutions
andrespa
Specialist
Specialist

Hi, you can reload the QVD do whatever you want and then export it to .csv like this:

STORE [YourTableName] into YourTableName.csv(txt);

Hope it helps,

Andrés

View solution in original post

4 Replies
viveksingh
Creator III
Creator III

you can try like


Table:

Load * from YourQVDFile;

store Table into Filename.csv(csv);

store Table into Filename.xls(xls);

andrespa
Specialist
Specialist

Hi, you can reload the QVD do whatever you want and then export it to .csv like this:

STORE [YourTableName] into YourTableName.csv(txt);

Hope it helps,

Andrés

sachinjoshilkar
Contributor II
Contributor II
Author

The file is created but neither opening in .csv nor in .xls

It isn't readable.

sachinjoshilkar
Contributor II
Contributor II
Author

Thnx Andres. That was helpful.