topic Re: Download to Data for Straight Tables: Table formatting feature returns Dual Field as numbers... not text in App Development

Download to Data for Straight Tables: Table formatting feature returns Dual Field as numbers... not text

Eug — Wed, 03 Aug 2022 10:43:55 GMT

Hi there

Not sure if anyone has noticed, but when I "Download to Data" a Straight Table that has a Dual Field as a Dimension, the App displays the Text (as desired) but the downloaded table in Excel using the Table formatting feature shows the Number (used for sorting)

Is this a known "issue"?

Re: Download to Data for Straight Tables: Table formatting feature returns Dual Field as numbers... not text

Or — Wed, 03 Aug 2022 10:53:58 GMT

According to the documentation, for formatted export "Dual fields that have both qText and qNum with no formatting are exported as number." I'm not sure why, but it seems that's intentional or at least known.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/DataExport/export-data.htm

Re: Download to Data for Straight Tables: Table formatting feature returns Dual Field as numbers... not text

Eug — Wed, 03 Aug 2022 11:06:20 GMT

Thanks Or. Appreciate your speedy response. I see Qlik has covered this (and themselves) here.

However, it does not make sense why this would be the case. Could anyone help with an explanation?

Re: Download to Data for Straight Tables: Table formatting feature returns Dual Field as numbers... not text

Or — Wed, 03 Aug 2022 11:15:58 GMT

I'm going to venture a completely uneducated guess that this is intended to deal with numbers that were not explicitly formatted. If you read a number from a data source and you haven't explicitly formatted it, you've ended up with a dual type that has no formatting on either the number or the text, but your expectation would still be that it be treated as a number when exported. That said, this is strictly guesswork and you'd need someone in the know for a definitive answer.

Re: Download to Data for Straight Tables: Table formatting feature returns Dual Field as numbers... not text

Eug — Wed, 03 Aug 2022 14:27:11 GMT

Thanks again, Or. A very helpful explanation.

Hoping "someone in the know" can provide "a definitive answer".

Re: Download to Data for Straight Tables: Table formatting feature returns Dual Field as numbers... not text

Smandar_Qlik — Tue, 06 Feb 2024 12:32:36 GMT

Do you know any ways to remove that

pop-up of table formatting?