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: 
Not applicable

how to show as a % of in a table with multiple dimensions

Dear All

I want to show the volumes as a percentage of the total volumes.

this works fine with below formula, where the dimension unit is ignored.

Sum(Volume)/ Sum({$< Unit= >}TOTAL Volume)))

but when I add the dimension Month on top it does not work anymore, as I want a 100% total for each month.

see attachment of what I am trying to achieve.

please to hear from you.

1 Solution

Accepted Solutions
Not applicable
Author

hi,

I did in sample qvw. please go through it...

Niranjan M.

View solution in original post

5 Replies
Not applicable
Author

try this

Sum(Volume)/ Sum({$< Unit= >}TOTAL Volume)

or this one

Sum(Volume)/ Sum(TOTAL Volume)

and then in chart properties-->number tab-->check on  show in percentage

er_mohit
Master II
Master II

Sum(Volume)/ Aggr(Sum(TOTAL Volume),Unit) or this one

Sum(Volume)/ Sum(TOTAL{$< Unit= >} Volume)))


Not applicable
Author

hi,

I did in sample qvw. please go through it...

Niranjan M.

Not applicable
Author

your option works , but not when I have the months on Top.

I replaced Unit with Month and that worked for me. thanks

Not applicable
Author

your option works , but not when I have the months on Top.

I replaced Unit with Month and that worked for me. thanks