Add AVG and MEDIAN functions to a drop down list

[vidyasagar159]

Hi ALL,

I have a simple aggregation function drop down list requirement and I am using Qlik Sense WEB Version only.

Example:

I have drop down extension already. Now I have added column called AGGRNAMES to it by creating an INLINE table in load script editor. Now these two Values called AVG and MEDAIN  are showing up in that drop down list. 

Measure:

SUM(Sales)  

Now when I select "AVG" from drop down list the function has to change in the measure. 

AVG(Sales)

I tried pick match but no luck.

Thanks in Advance!!

-Vidya

[rubenmarin · Accepted solution]

Hi Vidya, you can add a second field to your inline table to use as an index for Pick()

LOAD * Inline [

AGGRNAMES, IdAGGRNAMES

SUM, 1

AVG, 2

];

Expression: Pick(Min(IdAGGRNAMES), Sum(Sales), Avg(Sales))

[vidyasagar159]

Thank you. It worked.