topic Re: How to convert stacked bar chart in multicolor? in QlikView

How to convert stacked bar chart in multicolor?

prajapatiamar38 — Wed, 01 Jul 2015 05:48:01 GMT

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

Re: How to convert stacked bar chart in multicolor?

hariprasadqv — Wed, 01 Jul 2015 05:55:38 GMT

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.

Re: How to convert stacked bar chart in multicolor?

prajapatiamar38 — Wed, 01 Jul 2015 05:59:12 GMT

Hii

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

Thanks

Re: How to convert stacked bar chart in multicolor?

hariprasadqv — Wed, 01 Jul 2015 06:00:58 GMT

Can you share sample data!

Thanks

Re: How to convert stacked bar chart in multicolor?

hariprasadqv — Wed, 01 Jul 2015 06:02:19 GMT

How many preoperties are there in your dimensions!

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

Re: How to convert stacked bar chart in multicolor?

Siva_Sankar — Wed, 01 Jul 2015 06:02:20 GMT

Amarnath,

Find this thread stacked bar chart - define colours

Re: How to convert stacked bar chart in multicolor?

Wed, 01 Jul 2015 06:03:10 GMT

Hi Amarnath,

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

Ramya.

Re: How to convert stacked bar chart in multicolor?

hariprasadqv — Wed, 01 Jul 2015 06:06:44 GMT

Re: How to convert stacked bar chart in multicolor?

MK_QSL — Wed, 01 Jul 2015 06:10:03 GMT

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