topic Re: Expression in Variable, summing up when used in Chart in QlikView

Expression in Variable, summing up when used in Chart

dmohanty — Thu, 08 Nov 2018 14:43:48 GMT

Hi Team,

Its a pretty simple thing, but am stuck somehow.

Created a variable called, V_Expression = Sum {<Set Analysis>} (Sales)

Using the variable in a Straight Table, with a Single Dimension, let's say Product. I would expect it show as like this -

Where as its showing as -

Please help on how to still use the expression in Variable and use the variable in Chart.

andrey_krylov — Thu, 08 Nov 2018 14:47:55 GMT

Hi Dicky, this variable should be a string and not a calculated value

V_Expression = 'Sum {<Set Analysis>} (Sales)';

marcus_sommer — Thu, 08 Nov 2018 14:49:08 GMT

Your variable should contain:

Sum( {<Set Analysis>} Sales)

and not:

= Sum( {<Set Analysis>} Sales)

and then it should work.

- Marcus

dmohanty — Thu, 08 Nov 2018 15:30:22 GMT

Thank you. but some how not helping though adding it as a string. Did I miss anything?

andrey_krylov — Thu, 08 Nov 2018 16:28:00 GMT

Hard to say but most likely. What does it show now? And maybe some sample..

dmohanty — Fri, 09 Nov 2018 10:07:13 GMT

Thank you. this one helped.

But for some reason, I have to use the Sum ( ) again the expression part of the chart, like this = Sum (V_Expression).

Here its not allowing as a part of nested aggregation.

Can we use Aggr ( ) somehow in the expression part?

marcus_sommer — Fri, 09 Nov 2018 10:29:55 GMT

Yes, you will need an aggr() but if you could add them to the variable depends on your real expression. In this simplified case it should work:

V_Expression:

aggr(Sum( {<Set Analysis>} Sales), Dim1, Dim2)

and then:

sum($(V_Expression))

If not you could do it in this way:

sum(aggr($(V_Expression), Dim1, Dim2))

- Marcus