How to store file in an Excel format instead of QVD
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];
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.