I created a pivot table that i'd like to export in csv. In order to do that I wrote a macro, but when I run it the resulted document do not present the same format number of my pivot table in qlik. I mean, in my pivot table there are numbers like 3.900 or 1.090.600 etc..., while in the resulted csv I see 3900 or 1090600 (without dots).
What can I do?
Why QV do that?
Thanks for any suggestion
If you're exporting to CSV and then opening via Excel or other similar program, the data format will not be saved as you cannot pass meta data into CSV.
If Massimo's solution does not work for you, I recommend changing your default Excel settings to format the numbers as you want, or export to XLS in the first place to retain the wanted format.
new evolution... I've find out that opening the doc through access point and working with it there, its behaviour is quite different... That is the export in csv does not respect the options chosen while in client it does.
In access point the exported file present values such as 3900, while in client 3.900.
Why does this happen? Are there any configuration I must review?
Thanks u all guys!