This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have 2 equal fields, numeric because needed in intervalmatch, statements which do not give equal results:
(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(..&..&.. * 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
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
View solution in original post
Hello @michielvandegoo ,
Can you share a snippet of your data?