Expression in Variable, summing up when used in Chart

dmohanty — Wed, 25 Nov 2020 16:16:04 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 -

Product	Sales
P1	$200
P2	$500
P3	$300

Where as its showing as -

Product	Sales
P1	$1,000
P2	$1,000
P3	$1,000

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

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

rubenmarin — Wed, 14 Nov 2018 09:25:55 GMT

Hi, I think the variable content starts with an equal sign, so it is evaluated globally, and the result is shown in the chart.

To filter by dimensions remove the starting equal sign, this way only the expression goes to the chart, not the result, and dimension values are applied.

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

Expression in Variable, summing up when used in Chart

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