Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

prajapatiamar38
Contributor II

How to convert stacked bar chart in multicolor?

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...

8 Replies
hariprasadqv
Contributor III

Re: How to convert stacked bar chart in multicolor?

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
Contributor II

Re: How to convert stacked bar chart in multicolor?

Hii

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

Thanks

hariprasadqv
Contributor III

Re: How to convert stacked bar chart in multicolor?

Can you share sample data!

Thanks

hariprasadqv
Contributor III

Re: How to convert stacked bar chart in multicolor?

How many preoperties are there in your dimensions!

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

Siva_Sankar
Honored Contributor

Re: How to convert stacked bar chart in multicolor?

Amarnath,

Find this thread stacked bar chart - define colours

Not applicable

Re: How to convert stacked bar chart in multicolor?

Hi Amarnath,

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

Ramya.

Highlighted
hariprasadqv
Contributor III

Re: How to convert stacked bar chart in multicolor?

Capture.PNG

MVP
MVP

Re: How to convert stacked bar chart in multicolor?

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..