# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for
Did you mean:
Specialist

## If the Rank branch has zero stock. stay in red

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

Neves
2 Solutions

Accepted Solutions
MVP

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

Thanks & Regards,
Mayil Vahanan R
Master

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

3 Replies
MVP

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

Thanks & Regards,
Mayil Vahanan R
Specialist
Author

MayilVahanan Thank you very much

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