topic Calculate total by expressions values in QlikView

Calculate total by expressions values

francis_gr — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

In my attached sample i have a list box where i can select the expressions that i want to show in my chart.

The problem is that Total expression is always the sum of the other 3 expreesions, so i need that Total expression show only the sum of the selected expressions in the list box

Thanks in advance

Regards

Re: Calculate total by expressions values

jonathandienst — Mon, 14 Jan 2019 06:24:11 GMT

Reference the columns by name:

=Rangesum(sales1, sales2, sales3)

(RangeSum() will correctkt handle the null case when an expression is not selected)

Re: Calculate total by expressions values

francis_gr — Mon, 14 Jan 2019 07:28:44 GMT

Hi Jontydkpi!

It works ok!

Thanks for sharing your knowledge and for your time

regards