adapt rank for Dimensionality

[Ribeiro]

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

[MayilVahanan · Accepted solution]

Hi @Ribeiro 

May be, try like attachment.

[Kushal_Chawda · Accepted solution]

@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

[Ribeiro]

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

[Ribeiro]

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

[Ribeiro]

=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