Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sum of Rows vs Expression Total.

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,

1 Solution

Accepted Solutions
Highlighted

May be you want this

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


Capture.PNG

View solution in original post

7 Replies
Highlighted

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

Highlighted

May be try this

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

Highlighted
Creator
Creator

Hi Sunny...Thank you.

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

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

Highlighted
Creator
Creator

sunny

stalwar99

Please see the attached above

Highlighted

May be you want this

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


Capture.PNG

View solution in original post

Highlighted
Creator II
Creator II

Hi,

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

Highlighted
Creator
Creator

Awesomeness....Thank you.