Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
MEJ
New Contributor III

How to store file in an Excel format instead of QVD

Hi,

I normally store all my output files as QVD for different purposes, but I was planning to store some information in Excel files (output to our Sales force who don't have access to Qlikview). However, the below store command gives me a file that is stored in the right location, but it seems to be corrupt when I open it. I have tried with the ending .xlxs, .csv, but to no avail. Any idea?

Store Salesman_Excel into [X:\Salesman_File\Salesman_A.xls];

Not sure if I should add the following behind.

(ooxml, embedded labels, table is Sheet1)

1 Solution

Accepted Solutions
Partner
Partner

Re: How to store file in an Excel format instead of QVD

hi again,

 

STORE Salesman_Excel into [X:\Salesman_File\Salesman_A.csv] (txt);

View solution in original post

5 Replies
Partner
Partner

Re: How to store file in an Excel format instead of QVD

hi again,

 

STORE Salesman_Excel into [X:\Salesman_File\Salesman_A.csv] (txt);

View solution in original post

MEJ
New Contributor III

Re: How to store file in an Excel format instead of QVD

You saved my day!

Thanks

Partner
Partner

Re: How to store file in an Excel format instead of QVD

With pleasure!

You should look at your other post as well (the one with multiple selections in field).  

Have a great day!

MEJ
New Contributor III

Re: How to store file in an Excel format instead of QVD

I looked at them briefly with multiple selection. I will get to them, this week.

MEJ
New Contributor III

Re: How to store file in an Excel format instead of QVD

One of the problems with comma separated files, is that some fields might contain a comma. This will mess up the whole line, as none of the columns will match up. It's not a huge problem, but in case it would be material values, then it would be.

Is there a way to use another separator that is not as common as a comma? Semi colon would be less frequently used for example, or other signs.