topic Rank in QlikView

Rank

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

Hi All,

Please refer to the attached sample document, Can the individual article be arranged by their best color (based on Qty Sold Week 4) at the top and worst color at bottom? if i add additional ranking column then it's giving correct result. But i do not want to display the additional column. Is there anyway that the sorting logic be inserted into the color sort expression. Tried below expression in "Color" sort, but didn't give the expected output. kindly advise. Thanks

=aggr(Rank(sum([Qty_Sold WK_4])),ArticleNo,Color)

Re: Rank

sunny_talwar — Wed, 25 Jan 2017 16:17:29 GMT

This?

Replaced Color with a calculated dimension:

=Dual(Color, Aggr(Rank(Sum([Qty_Sold WK_4])),ArticleNo,Color))

Re: Rank

vishsaggi — Wed, 25 Jan 2017 16:26:29 GMT

Sunny, in his first image for second article no - The colors are BLACK, RED and NUDE?

Yours say BLACK, GREY and TAUPE? Just wondering ?

Re: Rank

sunny_talwar — Wed, 25 Jan 2017 16:28:08 GMT

Good point..... Let me check

Re: Rank

sunny_talwar — Wed, 25 Jan 2017 16:39:39 GMT

May be this

Where I added a new expression

=Rank(Sum([Qty_Sold WK_4]))

and then sort by y-value

and used the Macro to change the width of the first column to 0

Re: Rank

Anonymous — Wed, 25 Jan 2017 16:47:11 GMT

I opened the qvw and the below image is a result of your qvw. Where is the issue. I am a bit confused.

Re: Rank

vishsaggi — Wed, 25 Jan 2017 16:53:05 GMT

Hello Imad,

He does not want to use the Dimension field Name Rank by best Sold in that table. Remove that Field and see ?

Re: Rank

devarasu07 — Wed, 25 Jan 2017 17:01:33 GMT

Hi Sunny,

Thanks. your second approach working fine with correctly. last time i have tried to configured macros and it's not working. is there any way to avoid macros here. thanks

below issue facing while configuring and testing via IE plug in.

Exporting QV objects to a Excel document using macros?

Regards, Deva

Re: Rank

sunny_talwar — Wed, 25 Jan 2017 17:05:20 GMT

Its a one time macro... You can remove it once you have squeezed the column to 0 width. You never have to use or see it again.