top n analysis with 4 dimensions?

[gauthamchilled]

hi

anyone have idea on how to do top n analysis with more than 4 dimensions and more than 1 expression?

can anyone give me example?

Gautham

[gauthamchilled]

can any one help?

[varshavig12]

I am using personal edition

So i cannot open the qvw.

Still

It can be like:

if(rank(sum(Invoice))<=3,sum(Invoice))

[#4]

Not sure if I understood your requirement correctly. You are displaying values already, Just it should be sorted according to rank which can be done by giving "rank(sum(Invoice))" expression in sort option for customer.

At the same time if you want to display only top n items use following calculated dimension,

if(rank(sum(Invoice))<=3,Customer)

[gauthamchilled]

if i use this logic in my application it shows null values on expression

[varshavig12]

post a screenshot of your data and the expected value.

So, that everyone can help you to get the desired output.

[gauthamchilled]

i see null values if rank to see top 2 values

[gauthamchilled]

any one help?

is it really not possible ranking more than 3 dimensions?

[Anonymous]

Hi Gautham,

See attached.

Regards!