topic Re: Rank in Pivot Table with multiple dimensions in QlikView

Rank in Pivot Table with multiple dimensions

Thu, 27 Mar 2014 08:42:14 GMT

Hello

I have a Piovt table with 5 dimensions and on expression.for this i want to find the total sales .and for that total sales i want to find the rank also.this work i was done in Straight table.but when it is comes to pivot table The Rank is coming but when i use Collaspe all(-) the Rank also will change..i am getting "N" for all the sales. when i use expand(+) Then rank is coming..

So can any one please help me out in this issue

Re: Rank in Pivot Table with multiple dimensions

tresB — Thu, 27 Mar 2014 08:54:33 GMT

Although I guess that is the way qv should behave, to better realize, could you post a smaple qvw that demonstrates the issue?

Re: Re: Rank in Pivot Table with multiple dimensions

Thu, 27 Mar 2014 09:31:44 GMT

Hello

I have a Piovt table with 5 dimensions and on expression.for this i want to find the total sales .and for that total sales i want to find the rank also.this work i was done in Straight table.but when it is comes to pivot table The Rank is comming but when i use Collaspe all(-) the Rank also will change..i am getting "N" for all the sales. when i use expand(+) Then rank is comming..

So can any one please help me out in this issue

here is the sample data..

in this when i Group Collaspe all(-) :name field ,it will display rank 1

when i Group Collaspe all(-) :f.name field ,it will display rank 2

when i Group Collaspe all(-) :name field ,it will display rank 3