Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_B
Contributor
Contributor

Bar Graph colour

There is a field STATUS has (A,B,C). Here A B C has three measures for each SUCCESS,FAIL,DROP. I need to show SUCCESS bar in green, FAIL in red, DROP in orange.

 

Anil_B_0-1720499547364.png

 

Labels (3)
2 Replies
Sayed_Mannan
Creator
Creator

To customize the bar colors in QlikSense based on the STATUS field, you can create measures under Master Items and assign colors to each measure. Here’s how you can do it:

Navigate to Master Items in Qlik Sense.
Click on Measures, then click on Create New.
In the Edit Measure window, enter the expression for each status (A, B, C).
Select Measure color and choose the color you want to display for this measure.
For your specific case, you can use the following expressions for each status:

If (STATUS = 'SUCCESS', RGB(0,255,0),
If (STATUS = 'FAIL', RGB(255,0,0),
If (STATUS = 'DROP', RGB(255,165,0))))

This expression will assign the color green to ‘SUCCESS’, red to ‘FAIL’, and orange to 'DROP’. 

Now apply these measures to your bar chart. The bars in the chart will then be colored based on the STATUS field value.

 

I hope this helps, if it resolves your query please mark this as solution.

Anil_B
Contributor
Contributor
Author

Thanks for reply.

 

status(Zone1, Zone2,Zone3) for these Zone1(count of success, count of fail, count of drop),Zone2(count of success, count of fail, count of drop),Zone2(count of success, count of fail, count of drop) colour should applied to bars success,fail,drop