Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to set sequential color of a bar chart in Qlik Sense?

Hello all,

This is Qlik Sense app related. Does anyone know how can i achieve this kind of sequential color in Qlik Sense?

3 Replies
its_anandrjs

Hi,

For this you have to select the Colors by Measure for the settings

1. Appearances >> Colors And Legend.

2. Then select the By Measure.

3. Select the Sequential Classes (It depends on your requirement)

Regards

Anand

jim_chan
Specialist
Specialist
Author

i have selected Sequential Classes , but i want it to be in red color. cant change.

Patrik_Lundblad
Employee
Employee

Hi Fuan,

Currently you can't change the colors used, instead you can use the color by expression and a colormix function to create a gradient.

In this example

Measure: sum([Budget Amount])

Dimension: [Sales Rep Name]

Colormix1((sum([Budget Amount])-$(=min(aggr( sum([Budget Amount]), [Sales Rep Name]))))/$(=(max(aggr( sum([Budget Amount]), [Sales Rep Name]))-min(aggr( sum([Budget Amount]), [Sales Rep Name])))),Red(),Lightred())

Regards,

Patrik