topic Re: Download data from table to csv. But the information is incorrect. in App Development

Download data from table to csv. But the information is incorrect.

KKK1 — Fri, 15 Nov 2024 21:05:24 GMT

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.

This is a number that represents the operating time of the unit as HH:MM and the format as Duration.

This is formula.

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

Re: Download data from table to csv. But the information is incorrect.

GOKULAKANNAN — Thu, 01 Feb 2024 07:20:02 GMT

Hi @KKK1 ,

Try converting that to text format and export the data and check if its working

Re: Download data from table to csv. But the information is incorrect.

vinieme12 — Thu, 01 Feb 2024 07:53:40 GMT

There is already an Idea submitted for export to excel to retain QlikSense formatting

https://community.qlik.com/t5/Suggest-an-Idea/Keep-formatting-on-Excel-Export/idi-p/1700170/page/5#comments

for now you will have to reformat in excel again

Re: Download data from table to csv. But the information is incorrect.

KKK1 — Mon, 05 Feb 2024 03:55:54 GMT

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.

Re: Download data from table to csv. But the information is incorrect.

KKK1 — Mon, 05 Feb 2024 03:59:12 GMT

I don't even see the solution in the attached post. 😭