How to create a customized function

[#1]

Hi All,

I have one table:

Id, Numbers

1, 4

2, 6

3, 9

It is clear that 1 map to 4, 2 map to 6 and 3 map to 9.

However, if I have one Id says 1.5, I want to get 5 which is calculated based on Id 1 and 2.

So How to achieve it?

Thanks.

[#2]

Hi Isaac,

You could do an intervalmatch.

I asume that you use applymap at the moment, for intervalmatch just switch to a join

Klaus

[#3]

Sorry Isaac,

I did not take your head line into account.

Do you explicitly need a function cause you use that mapping at several places?

Klaus

[Vegar]

Please take a look at my attached example where I solve the problem in the script.

Altenatively you should be able to use rangesum() in the inteface or script after you managed to do the applymap on each value.

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se