Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))