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

[kunkumnaveen]

Hello All,

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

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

Thanks

[kunkumnaveen]

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

[shraddha_g]

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]

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

[kavita25]

Are you trying this in qliksense?

[Kushal_Chawda · Accepted solution]

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

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

[kunkumnaveen]

Yes ,i am doing it in qliksense

[kunkumnaveen]

Thanks Kushal

[kavita25]

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