topic Re: How to create a customized function in QlikView

How to create a customized function

Wed, 16 Jan 2013 06:54:30 GMT

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.

Wed, 16 Jan 2013 08:19:51 GMT

Hi Isaac,

You could do an intervalmatch.

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

Klaus

Wed, 16 Jan 2013 08:24:18 GMT

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 — Wed, 16 Jan 2013 08:26:51 GMT

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

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se