Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

How to get total based up on row level instead of global level

Hello All,

               Instead of 59912490.12 (1*277.32*216041) how to bring 31500460.345588 as Total


Capture.PNG

The above table has one material and three different vendors...

Thanks

1 Solution

Accepted Solutions
Kushal_Chawda

instead of column(1)*column(2)*column(3).. use actual expression enclosed in Aggr

sum(aggr(Expression1 * Expression2 * Expression3 , Material, Vendor))

View solution in original post

8 Replies
kunkumnaveen
Specialist
Specialist
Author

Is it possible to do ? can we have control on Total calculation because currently qlik give total

shraddha_g
Partner - Master III
Partner - Master III

Go to Measure Section.

Select Particular Measure.

There is an Option to Show Total.

There is a dropdown to show total as.

Select "SUM" as Option from Drop Down

shraddha_g
Partner - Master III
Partner - Master III

By Default it will be showing Auto. Change it to Sum

kavita25
Partner - Specialist
Partner - Specialist

Are you trying this in qliksense?

Kushal_Chawda

instead of column(1)*column(2)*column(3).. use actual expression enclosed in Aggr

sum(aggr(Expression1 * Expression2 * Expression3 , Material, Vendor))

kunkumnaveen
Specialist
Specialist
Author

Yes ,i am doing it in qliksense

kunkumnaveen
Specialist
Specialist
Author

Thanks Kushal

kavita25
Partner - Specialist
Partner - Specialist

Check total function under Measure Tab and choose "SUM" from the dropdown.