Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

farheenayesha
Contributor

How to add the values across Pivot table in Qliksense

Hi,

I want to calculate total rank as below. I am creating a Pivot table in Qliksense to achieve the below table. However i am not able to add the ranks across the platforms. Please help me to get the total rank as below.

     Untitled.png

3 Replies
vinieme12
Esteemed Contributor II

Re: How to add the values across Pivot table in Qliksense

use the TOTAL keyword

SUM(TOTAL <Region> YourExpression)

Refer below

When should the Aggr() function NOT be used?

farheenayesha
Contributor

Re: How to add the values across Pivot table in Qliksense

Hi Vineeth,    

          Thanks for your quick response.

      Actually i am using rank() function to calculate the rank against %to Goal. I cannot use rank function in your expression. Is there any other way that i can achieve the Rank total across the table.

vinieme12
Esteemed Contributor II

Re: How to add the values across Pivot table in Qliksense

Maybe the below sample can help you understand better

//Load Script

LOAD *,ceil(Rand()*500,10) as Sales INLINE [

    Region, Platform

    A, p1

    A, p2

    A, p3

    A, p4

    B, p1

    B, p2

    B, p3

    B, p4

];

Pivot Chart

Dimensions: Region , Platform

Expression:

=if(ColumnNo()=0,sum(AGGR(rank(sum(Sales),1,0),Platform,Region))

,rank(sum(Sales),1,0)

)

Community Browser