topic Create expression on a chart in QlikView

Create expression on a chart

Fri, 02 Dec 2016 11:38:50 GMT

Good morning, I have the following problem:
I defined an expression in a chart that gives me the sum of certain amounts.
I would create a second term on the basis of the amount present in the first expression.
The result is correct, but if you want to see the partial sums of this second expression, I get 0 as a result.

Someone can help me ?

Thanks

Re: Create expression on a chart

Gysbert_Wassenaar — Fri, 02 Dec 2016 11:43:16 GMT

If your using a straight table then set the Total mode of the expression to Sum of Rows. If it's a pivot table then use something like sum(aggr( ...original expression here ..., ...comma separated list of pivot table dimension names here... ))

Re: Create expression on a chart

Tue, 06 Dec 2016 10:37:13 GMT

ok but if I change the order of the column I obtain the total that I would.

It's strange ....

Why ???