topic Custom function in App Development

Custom function

Jaeger — Mon, 17 Feb 2020 14:04:19 GMT

Hello,
I want to use a description depending on a seleted value of a Variable input in a chart.
Is it possible to create custom functions in Qlik Sense.
I tried to put the formula in a variable like this
vKpiDesc =if($1='kpiSales','Sales €','Costs €')
and use vKpiDesc($(vKpi1)) in the description property of the chart.
But that doesn't seem to work.
Even if I put =if($(vKpi1)='kpiSales','Sales €','Costs €') directly into the description property of the chart it always shows the else-part of the if statement.
Any idea?

Re: Custom function

Anonymous — Tue, 18 Feb 2020 19:02:19 GMT

You dollar-expand the variable vKpi1 too often when you hand it over as $1 parameter.

Here how it works:

Variable definition

And then hand over the variable vKpi1 without a dollar expansion: =$(vKpiDesc(vKpi1))

Best regards,

Roland