number text format

[qlikhans]

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

[Oleg_Troyansky · Accepted solution]

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,

...

[qlikhans]

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?