String to number combined fields does not result in num

[Michiel_QV_Fan]

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

[eddie_wagt]

Hello @Michiel_QV_Fan ,

Can you share a snippet of your data?

Regards

Eddie

[Michiel_QV_Fan]

[eddie_wagt · Accepted solution]

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