topic Re: Variable in chart expression in QlikView

Variable in chart expression

AmCh — Mon, 27 Sep 2021 10:42:45 GMT

Hi all,

I defined a variable test_c which depends on ValueLoop(1,o) (o is variable as well).

I tried to create a bar chart with dimension ValueLoop(1,o) and expression test_c, but it is showing a constant value along all dimension values, which is not correct.

When I write the expression/formula of test_c explicity in chart expression, it is shown correctly.

How can I use a this variable correctly in chart expression?

Thanks in advance.

Re: Variable in chart expression

MarcoWedel — Tue, 28 Sep 2021 19:17:48 GMT

Hi,

can you please post a small example to demonstrate the issue and test solutions with?

thanks

Marco

Re: Variable in chart expression

AmCh — Thu, 30 Sep 2021 07:11:04 GMT

Hi,
test_c=ValueLoop(1,o)*3+m (o and m are input variables)

Dimension:

Expressions:

Result in chart:

Any help please?

Thanks in advance.

Re: Variable in chart expression

MarcoWedel — Sun, 03 Oct 2021 18:47:42 GMT

Try dollar sign expanding your variable like this:

hope this help

Marco