Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ribeiro
Specialist
Specialist

rank in ascending order

set analysis:

=Codigo & ' ' & aggr(concat(aggr(',' &'Filial ' & Filial& ' Stock ' & sum(Estoque)& ' RK ' & rank(sum(Estoque)), Codigo, Filial)), Codigo)

result:

100 ,Filial 1 Stock 100 RK 1,Filial 2 Stock 99 RK 2,Filial 3 Stock 88 RK 3
101 ,Filial 1 Stock 150 RK 2,Filial 2 Stock 151 RK 1,Filial 3 Stock 44 RK 3
102 ,Filial 1 Stock 380 RK 2,Filial 2 Stock 341 RK 3,Filial 3 Stock 560 RK 1

right:✔️

100 ,Filial 1 Stock 100 RK 1,Filial 2 Stock 99 RK 2,Filial 3 Stock 88 RK 3
101 ,Filial 2 Stock 151 RK 1,Filial 1 Stock 150 RK 2,Filial 3 Stock 44 RK 3
102 ,Filial 3 Stock 560 RK 1,Filial 1 Stock 380 RK 2,Filial 2 Stock 341 RK 3

can someone help me thank you.

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

 

Neves
1 Solution

Accepted Solutions
Kushal_Chawda

@Ribeiro  try below. see the attached

=code & ' ' & concat(aggr(' Branch ' & Branch & ' Stock ' & sum(stock)& ' RK ' & rank(sum(stock)), code, Branch),'',aggr(rank(sum(stock)),code,Branch))

 

Kush_0-1606581185051.png

View solution in original post

1 Reply
Kushal_Chawda

@Ribeiro  try below. see the attached

=code & ' ' & concat(aggr(' Branch ' & Branch & ' Stock ' & sum(stock)& ' RK ' & rank(sum(stock)), code, Branch),'',aggr(rank(sum(stock)),code,Branch))

 

Kush_0-1606581185051.png