Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ribeiro
Specialist
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

 

2020-11-28_16-52-55.jpg

Neves
2 Solutions

Accepted Solutions
MayilVahanan

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

MayilVahanan_1-1606613660545.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

edwin
Specialist III
Specialist III

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

View solution in original post

3 Replies
MayilVahanan

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

MayilVahanan_1-1606613660545.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

Ribeiro
Specialist
Specialist
Author

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

Neves
edwin
Specialist III
Specialist III

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

View solution in original post