Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
He Guys!
I need some help for my script:
Excel-Syntax:
=LOOKUP(A1;{0.51.151};{1,5.2.3,75})
Whats the syntax for my { }-condition?
Thank you!
LG
Michael
Try this:
Mapping:
Mapping
LOAD * Inline [
KM, Number
0, 1.5
51, 2
151, 3.75
];
Table:
LOAD KM,
ApplyMap('Mapping', If(KM < 50, 0, If(KM < 150, 51, 151))) as Number;
LOAD * Inline [
KM
100
34
60
190
134
24
];
Output:
You are seeking help with Excel or QlikView?
you need to give applymap function in Qlikview.
Vikas
For QlikView of corse
applymap function sounds ok.
Do you have an example for me?
Check this blog out:
Thanks. Thought about this already.
But an applymap and Inline Table only find exact matches.
But in my case i have to find a special number if km is between two values.
Here is the example:
In this case, the result = 2.
----------------------
QlikView Script:
Mapping load * inline [
km, number
0, 30
51, 40
151, 50
];
With an applymap i can only find the number to the exact km, or?
In this case, the Number is 100 -> incorrect
Only with km 0, 51 & 151 there is e correct match.
I hope I don’t think too complicated
Sorry for no confusion:
Mapping load * inline [
km, number
0, 1.5
51, 2
151, 3.75
];
You should look at Intervalmatch. See IntervalMatch
HIC
Try this:
Mapping:
Mapping
LOAD * Inline [
KM, Number
0, 1.5
51, 2
151, 3.75
];
Table:
LOAD KM,
ApplyMap('Mapping', If(KM < 50, 0, If(KM < 150, 51, 151))) as Number;
LOAD * Inline [
KM
100
34
60
190
134
24
];
Output:
Yea, thank you.
At the end it seems so clear an easy