topic Re: String to number combined fields does not result in num in QlikView

String to number combined fields does not result in num

Michiel_QV_Fan — Thu, 01 Apr 2021 08:53:44 GMT

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:

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 — Thu, 01 Apr 2021 09:19:29 GMT

Can you share a snippet of your data?

Regards

Eddie

Michiel_QV_Fan — Thu, 01 Apr 2021 09:28:59 GMT

eddie_wagt — Thu, 01 Apr 2021 09:46:25 GMT

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