topic Re: adding user defined function in QlikView

adding user defined function

Wed, 20 May 2015 07:22:00 GMT

hello..

i want to reare a user defined fucntions..so that user can use it.

Say for example : Top 5 is my user defined function..so the code required to calculate it will be already written..

so when user uses top5 we need to just pass aametre like based on what we need top5.can anyone suggest.

I tried for simle sum..it didnt work.

What i did is i created a variable v_sum assigned as sum(@1)

in the chart i used =v_sum (salary) but it is not considering it as function.I trie done more option as =$(v_sum (salary))

even this didnt work.

Regards,

Prajna

tresB — Wed, 20 May 2015 07:33:14 GMT

Define v_sum like: Sum($1)

Then call it like: $(v_sum(AmountField))

Gysbert_Wassenaar — Wed, 20 May 2015 07:35:49 GMT

define v_sum as sum($1) instead. The $1 is the parameter. The expression using the variable would be: $(v_sum(salary))

Wed, 20 May 2015 07:36:18 GMT

oh..okay

I had added @ instead of $

Thanks & Regards

Prajna

Wed, 20 May 2015 07:36:43 GMT

How do you define a sum?