Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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