Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use the TOTAL keyword
SUM(TOTAL <Region> YourExpression)
Refer below
When should the Aggr() function NOT be used?
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.
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)
)