topic number text format in QlikView

number text format

qlikhans — Sat, 16 Nov 2024 01:56:41 GMT

Hi all,

I expect it to be a small issue, but....

I have:

1. a budget with cognos reporting codes and some amounts

2. the reporting codes with descriptions and groupings.

I want to link 1. to 2. and report according the groupings.

THe grouping does not work, I think it has to do with text that looks like numbers connecting to numbers or something like that.

How can I avoid this?

How can I verify that something like this is happening?

thanks for your support

Hans

Re: number text format

Oleg_Troyansky — Thu, 14 Nov 2019 22:41:50 GMT

Hi Hans!

Your suspicion is absolutely correct - the Cognos Code is loaded as a text in the Budget table, and it's loaded as a number in the Categorization table. In order to load both codes as text, wrap the field name in the function text() in your load statement:

LOAD

...

text(Code) as Code,

...

Re: number text format

qlikhans — Fri, 15 Nov 2019 09:01:33 GMT

Hi Oleg,

Thank you for the solution. Would there be a method to find out that this will happen, or is it simply: script and run into the problem?