topic Re: rank in QlikView

rank

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

Can we rank based on each dimension

for example.: I have a straight table with Cyclic Dimension and Sales Amount.My cyclic Dimension has the following below dimension.

Product

Product ID

Country

Sales Person

few more

So for example if i select Product | Sales Amount -- > The Sales amount should be ranking based on the top sold product

If i select Sales Person -------->The Sales amount should be ranking based on the top sales done on the Sales person

once i change the dimesnion it should be able to rank it.. i have totally 7-8 dimesnions which i would rank..

Re: rank

Anil_Babu_Samineni — Mon, 10 Oct 2016 10:09:01 GMT

Have you tried any expression or better approach if you share more information

Re: rank

vinieme12 — Mon, 10 Oct 2016 10:27:10 GMT

Create a variable to capture your group selection

say,

VGroupselection = GetCurrentField([GroupFieldName])

Now use this variable to aggregate your Rank expression

AGGR(Rank() , $(VGroupselection ) )

Re: rank

vinieme12 — Mon, 10 Oct 2016 10:35:01 GMT

This is the same of what I just explained!

Re: rank

adamdavi3s — Mon, 10 Oct 2016 10:39:57 GMT

ha it is, sorry I was obviously writing up as you posted. I'll remove my answer

Re: rank

vinieme12 — Mon, 10 Oct 2016 10:43:11 GMT

oh no, I was expecting to see another method

Re: rank

adamdavi3s — Mon, 10 Oct 2016 10:44:51 GMT

haha no, yours is by far the best way I would say, I was just too slow in creating my QVW

Re: rank

sunny_talwar — Mon, 10 Oct 2016 10:50:58 GMT

Not sure I understand the use of Aggr() function here?

Why can't we just use Rank(Sum([Sales Amount])) here? I mean as the dimension changes, the Rank() would automatically be based on the dimension we are seeing, why do we need to add Aggr() here? Sorry, if I missed something important detail here

Re: rank

adamdavi3s — Mon, 10 Oct 2016 10:59:23 GMT

I think I just assumed there would be more than one dimension in the table

Re: rank

sunny_talwar — Mon, 10 Oct 2016 11:02:32 GMT

I guess my concern here is that what is the use of naked Aggr() function. We don't need to for sorting also, so just not sure why would need it even if we have multiple dimensions

Re: rank

vinieme12 — Mon, 10 Oct 2016 11:42:50 GMT

I assumed the OP is trying to achieve a calculated dimension , if he had already tried rank in expression this post would have been out of the question.

Just an assumption!

Re: rank

sunny_talwar — Mon, 10 Oct 2016 11:46:29 GMT

Now that would make a lot of sense.

Re: rank

raadwiptec — Thu, 13 Oct 2016 12:06:40 GMT

Hi vineeth

the groups was created at the front end.. in the chart. How can i make a variables in the script?

Re: rank

vinieme12 — Fri, 14 Oct 2016 05:55:32 GMT

Why do you want to create this variable in the script though?

SET VGroupselection = GetCurrentField([GroupFieldName]) ;

Re: rank

raadwiptec — Thu, 20 Oct 2016 07:02:16 GMT

ok vineeth got it.. i will test it