Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
michielvandegoo
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
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

View solution in original post

3 Replies
eddie_wagt
Partner
Partner

Hello @michielvandegoo ,

Can you share a snippet of your data?

Regards

Eddie

michielvandegoo
Specialist
Specialist
Author

michielvandegoo_0-1617269331728.png

 

eddie_wagt
Partner
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

View solution in original post