How to convert stacked bar chart in multicolor?

[prajapatiamar38]

Hello Community,

I have one application in that i have created one stacked bar chart.I have used two expressions.And i am showing top                             five.It is showing the top 5 bars.

But my requirement is i want each bar have different colors.Is it possible Please help me...

[hariprasadqv]

Hi,

Use multy color under colors tab with persitence and chart style as grouped.

*Posting sample data or desired outcome screenshot will help community to address your issue

Thanks.

[prajapatiamar38]

Hii

    But in stack bar chart multicolor option is disabled.We cant do multicolor in stack i tried.

Thanks

[hariprasadqv]

Can you share sample data!

Thanks

[hariprasadqv]

How many preoperties are there in your dimensions!

depends on that you can color the bars in expression tab.

[Siva_Sankar]

Amarnath,

Find this thread stacked bar chart - define colours

[#7]

Hi Amarnath,

U can use Color tab. ther u will have option.

Ramya.

[hariprasadqv]

[MK_QSL]

Go to Expression

Click on + sign of Expression

Write Below Expression under BackGround Color

IF(RANK(TOTAL SUM(TotalSales))=1, Green(),

IF(RANK(TOTAL SUM(TotalSales))=2, Blue(),

IF(RANK(TOTAL SUM(TotalSales))=3, QlikTechGray(),

IF(RANK(TOTAL SUM(TotalSales))=4, Black(),

IF(RANK(TOTAL SUM(TotalSales))=5, RGB(40,50,50))))))

=====================================

SUM(TotalSales) is Expression which is for my first Expression.

You can swap it with expression you used in your application.

Also, similar approach need to be done in second expression. Use colors as per your choice..