Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"?
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.
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.
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.
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?
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.
Thanks again, Or. A very helpful explanation.
Hoping "someone in the know" can provide "a definitive answer".
Do you know any ways to remove that
pop-up of table formatting?