- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
The above table has one material and three different vendors...
Thanks
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
instead of column(1)*column(2)*column(3).. use actual expression enclosed in Aggr
= sum(aggr(Expression1 * Expression2 * Expression3 , Material, Vendor))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is it possible to do ? can we have control on Total calculation because currently qlik give total
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
By Default it will be showing Auto. Change it to Sum
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you trying this in qliksense?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
instead of column(1)*column(2)*column(3).. use actual expression enclosed in Aggr
= sum(aggr(Expression1 * Expression2 * Expression3 , Material, Vendor))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes ,i am doing it in qliksense
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Kushal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check total function under Measure Tab and choose "SUM" from the dropdown.