Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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

View solution in original post