Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Highlighted
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.