topic Re: Sum of Rows vs Expression Total. in QlikView

Sum of Rows vs Expression Total.

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

Hi ,

I have below expression in the bar chart.

My dimension is Called Type.

=(If(GetFieldSelections(_BTUnitOfMeasure)='SQF',

(Sum([RSF])),

(Sum([RSF]))) * SUM(Value)

I am not getting the desired number,So tried with the straight table.Here I get different number with Expression total and sum of rows.

How can I get the same with both options.

Thank you,

sunny_talwar — Fri, 12 May 2017 14:12:24 GMT

What are you getting and what was expected? Do you have a sample or images to show?

sunny_talwar — Fri, 12 May 2017 14:13:20 GMT

May be try this

=If(GetFieldSelections(_BTUnitOfMeasure) = 'SQF', Sum([RSF]), Sum([RSF]) * Sum(Value))

apthansh — Fri, 12 May 2017 15:01:46 GMT

Hi Sunny...Thank you.

I have attached 2 files...QVW and excel.

How can I get sum of rows number in bar char ?

apthansh — Fri, 12 May 2017 15:08:03 GMT

Please see the attached above

sunny_talwar — Fri, 12 May 2017 15:11:29 GMT

May be you want this

Sum(Aggr(Sum(RSF)*Sum(VALUE), ID, Segment))

tripatirao — Fri, 12 May 2017 15:13:15 GMT

Hi,

Can you tell us which output your trying to get in the excel.

apthansh — Fri, 12 May 2017 16:09:53 GMT

Awesomeness....Thank you.