topic Re: top n analysis with 4 dimensions? in QlikView

top n analysis with 4 dimensions?

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: top n analysis with 4 dimensions?

varshavig12 — Tue, 21 Jun 2016 06:05:44 GMT

Rank function can help you

Re: top n analysis with 4 dimensions?

gauthamchilled — Tue, 21 Jun 2016 06:12:47 GMT

can you give me an example with 4 dimensions?

Re: top n analysis with 4 dimensions?

Anonymous — Tue, 21 Jun 2016 06:27:29 GMT

Hi Gautham,

Do your rank, with rank function, using the last level dimension.

Regards!

Re: top n analysis with 4 dimensions?

Digvijay_Singh — Tue, 21 Jun 2016 06:35:26 GMT

See if this can help, I cannot open qvw(using PE) so not sure what is there inside -

Re: Ranking with multiple Dimensions

Re: top n analysis with 4 dimensions?

susovan — Tue, 21 Jun 2016 06:47:45 GMT

Hi Gautham,

Is it your requirement?

Re: top n analysis with 4 dimensions?

sujeetsingh — Tue, 21 Jun 2016 06:53:23 GMT

There are number of ways well you can use combo charts or straight tables.

Re: top n analysis with 4 dimensions?

varshavig12 — Tue, 21 Jun 2016 07:14:36 GMT

It depends on your requirement.

You can either do top analysis on the basis of a particular dimension.

Else for multiple dimension

You can check the link which digvijay‌ has given.

Re: top n analysis with 4 dimensions?

varshavig12 — Tue, 21 Jun 2016 08:06:44 GMT

Can you post a sample of your data and the expected output ?

Re: top n analysis with 4 dimensions?

gauthamchilled — Tue, 21 Jun 2016 08:19:37 GMT

Thanks for all...in the attached example...it shows the rank..instead of showing rank..i want to show their values..

eg top 3 values instead of the ranking..

rank(sum(Invoice)) shows only ranks...not the values ..i want values

how can i do that?

Re: top n analysis with 4 dimensions?

gauthamchilled — Tue, 21 Jun 2016 08:39:16 GMT

can any one help?

Re: top n analysis with 4 dimensions?

varshavig12 — Tue, 21 Jun 2016 08:45:48 GMT

I am using personal edition

So i cannot open the qvw.

Still

It can be like:

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

Re: top n analysis with 4 dimensions?

Tue, 21 Jun 2016 08:51:41 GMT

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)

Re: top n analysis with 4 dimensions?

gauthamchilled — Tue, 21 Jun 2016 08:57:43 GMT

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

Re: top n analysis with 4 dimensions?

varshavig12 — Tue, 21 Jun 2016 09:07:30 GMT

post a screenshot of your data and the expected value.

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

Re: top n analysis with 4 dimensions?

gauthamchilled — Tue, 21 Jun 2016 09:13:55 GMT

i see null values if rank to see top 2 values

Re: top n analysis with 4 dimensions?

gauthamchilled — Tue, 21 Jun 2016 09:31:28 GMT

any one help?

is it really not possible ranking more than 3 dimensions?

Re: top n analysis with 4 dimensions?

Anonymous — Tue, 21 Jun 2016 09:38:21 GMT

Hi Gautham,

See attached.

Regards!