topic Re: Dynamic expressions without Pick in QlikView

Dynamic expressions without Pick

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a scenario where the table looks like this.

MetricName, VariableName

m1, v1

m2,v2

m3,v3

m4,v4

I need to display a chart with "MetricName" and the result of the evaluation of the variable in a chart. Let us say the variable contains sum(<field>).

Can't get it to work. Anyone tried this. Please see the attachment. However it works when you select just one metric.

Re: Dynamic expressions without Pick

marcus_sommer — Fri, 29 Apr 2016 07:11:04 GMT

It's not possible in this way because you will need $-sign expansion to evaluate the expression and this will be caluculated only once before the chart is calculated and then applied for each row. Therefore you will need mandatory an approach with if-loops or better a pick(match()) to get unique expression for each row - whereby this could be applied automatically, see also:

AllowMacroFunctionsInExpressions AND ActiveDocument.Evaluate()

https://community.qlik.com/ideas/4429#comment-45051

- Marcus

Re: Dynamic expressions without Pick

christophebrault — Fri, 29 Apr 2016 09:28:04 GMT

Hi,

See the attached document

Use Valuelist() as a dimension and then and if statement in your expression to change it depending on the value in valuelist() function

Re: Dynamic expressions without Pick

sunny_talwar — Fri, 29 Apr 2016 12:27:02 GMT

I think do this, you won't even need a synthetic dimension. But I guess the issue is that using pick or if over large number of dimension is what the OP is trying to avoid.

Attaching the non-valuelist version of your proposed solution

Re: Dynamic expressions without Pick

lavielme — Wed, 24 Aug 2016 13:43:30 GMT

Hay All

Thank's For Your Help

But I'M Trying To Avoied From If Statement

To Optimize The Performance to Some Model

That is The Reson That I posted This Quastion