topic Re: Percentage relative to Total? in QlikView

Percentage relative to Total?

dmohanty — Thu, 03 Apr 2014 06:43:05 GMT

Hi All,

The requirement is simple, but I am not getting the desired results. Please help.

I have to show the Total Sales or Count of Orders per each Region. That's easy.

Along with that I need to show the Percentage of Sales/ Count comapred to Total Sales or Total Count.

How to achieve this?

Re: Percentage relative to Total?

arsal_90 — Thu, 03 Apr 2014 07:41:18 GMT

Can u elaborate your requirement in excel. Mention the columns and dumy data in excel and also mention the desired result what u want

Re: Percentage relative to Total?

Thu, 03 Apr 2014 07:41:21 GMT

Try this:-

sum(Amount)/sum(TOTAL Amount)

Re: Percentage relative to Total?

MK_QSL — Thu, 03 Apr 2014 08:28:26 GMT

Please check enclosed file.

There are three different %TOTAL given.

Choose your desired one...

Re: Percentage relative to Total?

Anonymous — Thu, 03 Apr 2014 08:28:48 GMT

Hi,

check this.

The expression is on the caption bar.

Re: Percentage relative to Total?

Thu, 03 Apr 2014 08:31:42 GMT

Hi,

if you work with straigt table you can use the option Relative.

For pivot table you have to use the total function in your expression:

sum(Sales)/sum(total Sales)

sum(Count)/sum(total Count)

Re: Percentage relative to Total?

dmohanty — Thu, 03 Apr 2014 09:15:31 GMT

Thank you very much Manish, for this great help.

Re: Percentage relative to Total?

dmohanty — Fri, 25 Apr 2014 09:32:50 GMT

Hi,

I am reposting in this thread as a bit enhancement required. My requirement is below:

Whenever I would select any dimension, let say Customer 'A' or Region 'R1' (from the QVW of the correct answer),

the values of the % Total should not change. It should show the values respective to the Total what was there when no selections were made. However, the chart would show only the selected dimensions, bu the Measures should show esactly the same when no selections are made.

Example, If I select Customer 'A', it should show 6.13% and 17.54% (these values are showin when nothing is selected), I would not see 100% and 100%.

Please help me on this.

Re: Percentage relative to Total?

MK_QSL — Fri, 25 Apr 2014 09:45:21 GMT

Can you please create a new thread please? so that other member can also answer.