Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

adding user defined function

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Define v_sum like:        Sum($1)          

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

View solution in original post

4 Replies
tresesco
MVP
MVP

Define v_sum like:        Sum($1)          

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

oh..okay

I had added @ instead of $

Thanks & Regards

Prajna

Not applicable
Author

How do you define a sum?