If the Rank branch has zero stock. stay in red

[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))

If the Rank branch has zero stock. stay in red

Codigo   Rank
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

[MayilVahanan · Accepted solution]

HI @Ribeiro 

We can't display half red / half black in the straight table single cell. So either you can display in 2 different column. or try like below

Sum(If(Aggr(sum(Estoque), Codigo, Filial)=0,Lightred(), Black()))

[Ribeiro]

MayilVahanan Thank you very much

if you have time see this topic, tried to separate to paint the color red.🤔

https://community.qlik.com/t5/QlikView-Scripting/adapt-rank-for-Dimensionality/m-p/1765115#M100641

[edwin · Accepted solution]

that is correct, you cant mix colors in a single cell of a chart out of the box, you need to create an extension for that.  see attached