Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
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)
1 Solution

Accepted Solutions
eddie_wagt
Partner - Creator III
Partner - Creator III

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

View solution in original post

3 Replies
eddie_wagt
Partner - Creator III
Partner - Creator III

Hello @Michiel_QV_Fan ,

Can you share a snippet of your data?

Regards

Eddie

Michiel_QV_Fan
Specialist
Specialist
Author

michielvandegoo_0-1617269331728.png

 

eddie_wagt
Partner - Creator III
Partner - Creator III

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