topic Re: Ranking in QlikView

Ranking

atsnal90 — Fri, 16 Nov 2018 10:20:09 GMT

Hi all,

I'm trying to do rank table something like this: https://ibb.co/bQEMpf

I think use ValueLoop in dimension, but i dont know what write in expression

Can some one please help here?

The application file with test data and my object in attachment

Thanks!

Re: Ranking

agni_gold — Fri, 16 Nov 2018 09:55:12 GMT

Your link is not opening , can you please post snapshot of your requirement

Re: Ranking

atsnal90 — Fri, 16 Nov 2018 10:20:54 GMT

added

Re: Ranking

agni_gold — Fri, 16 Nov 2018 10:39:04 GMT

Check this

Re: Ranking

atsnal90 — Fri, 16 Nov 2018 12:07:40 GMT

yes, its works(it was necessary to add additional dimension to aggr statement because i need different rank for region).

But in my report i have alot of data ( full size of report: 14 Gb) and this object(with two dimension in aggr) cant calculate in the server 😞 .

Maybe you know another way?

Re: Ranking

Anonymous — Thu, 20 Dec 2018 05:19:00 GMT

I think use ValueLoop in dimension, but i dont know what write in expression
Can some one please help here?
The application file with test data and my object in attachment
Thanks!

I think I am also facing this issue. Did you get any proper solution?