Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why did I download table from Qlik as a csv file. And the numbers aren't right.
It's like in Qlik, it's a format duration, but when opened in Excel on web, it turns into a different format.
My question is 1.Explain why it's like this. 2.How to edit by editing that Qlik is not Excel (I want to import completely data and Don't want to fix by excel.)
When I am editing as text and then imported into excel, the number that is seen as string requires editing in excel, which I do not want to be edited in excel again.
you would need an extension to retain formats
https://github.com/iviasensio/SmartExport
https://logiexport.logsys.co.il/
You could try to format the number in the load script (or in table), using interval function:
so when you want to export the set you can keep the original formatting.
Does it work for you?
S.
It doesn't work sir😥
I was tried to format the number in table
Did you try to format it in the load script?
S.
Yes, I did!