topic Re: adapt rank for Dimensionality in QlikView

adapt rank for Dimensionality

Ribeiro — Sun, 29 Nov 2020 12:24:20 GMT

Set analysis:

=Codigo & ' ' & concat(aggr(' - '&' FL: ' & Filial & ' ET: ' & NUM(sum(Estoque),'000000')& ' RK: ' &NUM(rank(sum(Estoque)),'00'), Codigo, Filial),'',aggr(rank(sum(Estoque)),Codigo,Filial))

The result of the set analysis:

100 100 - FL: 2 ET: 000099 RK: 01 - FL: 3 ET: 000088 RK: 02 - FL: 1 ET: 000000 RK: 03
101 101 - FL: 2 ET: 000151 RK: 01 - FL: 1 ET: 000150 RK: 02 - FL: 3 ET: 000044 RK: 03
102 102 - FL: 3 ET: 000560 RK: 01 - FL: 1 ET: 000380 RK: 02 - FL: 2 ET: 000341 RK: 03

What I need to do

It's possible?

Codigo	RK: 01	RK: 02	RK: 03
100	FL: 2 ET: 000099	FL: 3 ET: 000088	FL: 1 ET: 000000
101	FL: 2 ET: 000151	FL: 1 ET: 000150	FL: 3 ET: 000044
102	FL: 3 ET: 000560	FL: 1 ET: 000380	FL: 2 ET: 000341

Re: adapt rank for Dimensionality

MayilVahanan — Sun, 29 Nov 2020 14:40:12 GMT

Hi @Ribeiro

May be, try like attachment.

Re: adapt rank for Dimensionality

Kushal_Chawda — Sun, 29 Nov 2020 15:42:57 GMT

@Ribeiro try like attached if you want your Rank to be dynamic so that you don't need to create expression for each rank manually

Re: adapt rank for Dimensionality

Ribeiro — Sat, 05 Dec 2020 11:27:49 GMT

https://community.qlik.com/t5/QlikView-Scripting/the-program-values-for-resale-How-to-hide-Customers-without/td-p/1766463

Re: adapt rank for Dimensionality

Ribeiro — Sat, 05 Dec 2020 11:28:06 GMT

https://community.qlik.com/t5/QlikView-Scripting/the-program-values-for-resale-How-to-hide-Customers-without/td-p/1766463

Re: adapt rank for Dimensionality

Ribeiro — Wed, 28 Apr 2021 13:46:13 GMT

=Codigo & ' ' & concat(aggr(' - '&' FL: ' & Filial & ' ET: ' & NUM(sum(Estoque),'000000')& ' RK: ' &NUM(rank(sum(Estoque)),'00'), Codigo, Filial),'',aggr(rank(sum(Estoque)),Codigo,Filial))

I need to separate into two columns = 0000 and <> 00000

in the set analysis above