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

How to store file in an Excel format instead of QVD

MEJ — Wed, 25 Nov 2020 16:16:04 GMT

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)

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

andrei_delta — Wed, 03 Jul 2019 13:52:01 GMT

hi again,

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

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

MEJ — Wed, 03 Jul 2019 14:01:04 GMT

You saved my day!

Thanks

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

andrei_delta — Wed, 03 Jul 2019 14:06:20 GMT

With pleasure!

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

Have a great day!

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

MEJ — Wed, 03 Jul 2019 14:13:07 GMT

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

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

MEJ — Thu, 04 Jul 2019 09:39:56 GMT

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.

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

QlickySense — Tue, 13 Jul 2021 13:22:33 GMT

Hi,

I don't know if you managed to resolve your problem as it is 2021 but maybe someone else will witness similar problem (for instance I got into this thread today)

To solve it (so create separator other than coma) please use

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

for tab

(txt, delimiter is '\t');