Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

qlikconsult
New Contributor III

Percentage % Total for Dimension in Pivot Table

Hey

Hope someone can assist me with the following

I have a pivot table with 2 expressions over three dimensions

The dimensions are:

Phase, Type and Side

The expressions are:

For Nr:

count(rowno)

For %:

count(rowno) / count(total rowno)

(See next image)

In the pivot table, I would like to show the % as summing up to 100%.r1.png

For example, in the image, in the column "CUT" under %, it should show 100% in the top total, and then for example General Play - Off-Side should show 20% (see image below where I have just filtered down to side). So, where it shows 2.41% in the top image, it should show 20%

r2.png

I have tried several different combinations of aggr functions, for example

sum(aggr( count(rowno) / count(total rowno),Side))

or count(rowno) / sum(aggr(count (total rowno),Side))

and a few others, but have not been able to resolve.

Do anyone have an idea which could help?

I'm attaching the model with the object (data reduced, so % can differ from mentioned above), hope this helps

Tags (1)
1 Solution

Accepted Solutions

Re: Percentage % Total for Dimension in Pivot Table

Change your second expression as below..

count(Game_Activity_RowNo)

/

count(Total <Game_Side_Code> Game_Activity_RowNo)

5 Replies
Not applicable

Re: Percentage % Total for Dimension in Pivot Table

HI

PFA

qlikconsult
New Contributor III

Re: Re: Percentage % Total for Dimension in Pivot Table

Hi

Nirmal's attached file above seems to be exactly the same as what I attached

So just be clear,

on the example I attached with view:

r3.png

I need to see:

r5.png

Re: Percentage % Total for Dimension in Pivot Table

Change your second expression as below..

count(Game_Activity_RowNo)

/

count(Total <Game_Side_Code> Game_Activity_RowNo)

Not applicable

Re: Re: Re: Percentage % Total for Dimension in Pivot Table

pfa

qlikconsult
New Contributor III

Re: Percentage % Total for Dimension in Pivot Table

Wow, thanks Manish, that seems to have solved my problem

Community Browser