Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikhans
Creator
Creator

number text format

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

 

Labels (2)
1 Solution

Accepted Solutions
Oleg_Troyansky

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,

...

 

View solution in original post

2 Replies
Oleg_Troyansky

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
Creator
Creator
Author

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?