# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Specialist

## String to number combined fields does not result in num

Hi,

I have 2 equal fields, numeric because needed in intervalmatch, statements which do not give equal results:

This statement:

(A) Num(Country & RatecardLaneVersion & Coll_PC_From_shipment) as To_find_collection

results in a number,

while this statement:

(B) Del_Country & RatecardLaneVersion & Del_PC_From_shipment as To_find_delivery

results in a correct combined string but this statement:

(C) Num(Del_Country & RatecardLaneVersion & Del_PC_From_shipment) as To_find_delivery

results in an empty field. These 3 fields are by themselves \$numeric;\$integer

I tested the following solutions I found in the community:

Num(Num#(..&..&..))

Num(..&..&.. * 1)

Num(..&..&..)*1

but nothing gives me back a number.

There are only numbers in the combined fields.

Parsing C with IsNum and IsText gives for both 0 as result.

Any ideas to get C act as a number? Thanks

Labels (1)
• ### Scripting

1 Solution

Accepted Solutions
Partner

Hello Michiel,

It is due the fact that the number contains too many characters for Qlik to parse as a number. The simplest trick is to use  Evaluate([Field(s)].

evaluate(Del_Country & RatecardLaneVersion & Del_PC_From_shipment) as To_find_delivery

Regards

Eddie

3 Replies
Partner

Hello @michielvandegoo ,

Can you share a snippet of your data?

Regards

Eddie

Specialist
Author

Partner

Hello Michiel,

It is due the fact that the number contains too many characters for Qlik to parse as a number. The simplest trick is to use  Evaluate([Field(s)].

evaluate(Del_Country & RatecardLaneVersion & Del_PC_From_shipment) as To_find_delivery

Regards

Eddie

Community Browser