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: 
farheenayesha
Creator
Creator

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
Champion III
Champion III

use the TOTAL keyword

SUM(TOTAL <Region> YourExpression)

Refer below

When should the Aggr() function NOT be used?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
farheenayesha
Creator
Creator
Author

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
Champion III
Champion III

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)

)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.