Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ribeiro
Specialist
Specialist

adapt rank for Dimensionality

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?

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

 

 

2020-11-28_11-38-38.jpg

Neves
2 Solutions

Accepted Solutions
MayilVahanan

Hi @Ribeiro 

May be, try like attachment.

 

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

Kushal_Chawda

@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

 

View solution in original post

5 Replies
MayilVahanan

Hi @Ribeiro 

May be, try like attachment.

 

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Kushal_Chawda

@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
Specialist
Specialist
Author

=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

2021-04-28_10-42-41.jpg

Neves