Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jim_chan
Contributor III

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

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

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

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

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

plu
Contributor III

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

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