Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

hi,

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

Niranjan M.

View solution in original post

5 Replies
Highlighted
Not applicable

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

Highlighted
Master II
Master II

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

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


Highlighted
Not applicable

hi,

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

Niranjan M.

View solution in original post

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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