Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
scotly-victor
Contributor II

Custom Color in Measure Without Value List

Hi Eveyone,

                   I have one dimension and three measures , I wanted give color based on measure value ,I know by using value list we can achieve it .However my requirement is without using valuelist  I wanted to give color to my three measure

12 Replies
shivkumar300
New Contributor III

Re: Custom Color in Measure Without Value List

can you provide some sample data

scotly-victor
Contributor II

Re: Custom Color in Measure Without Value List

Please find attached qvf

shivkumar300
New Contributor III

Re: Custom Color in Measure Without Value List

Can you please elaborate the requirement...  Colour can be changed accordingly please find the below print screen if helpful or else guide me more on the requirement.

Qliksense.JPG

Not applicable

Re: Custom Color in Measure Without Value List

Scotly,

Go to Appearance / Colors and legends.

Then choose custom colors and then select multi coloured..

Now you can see different colours in the bars..

Regards,

Rajesh R. S.

scotly-victor
Contributor II

Re: Custom Color in Measure Without Value List

Hi,

In above sample there are two measure (CYsales,PYsales)

I want to give red color to CYsales and blue color to PYsales

Thanks

rahulpawarb
Valued Contributor III

Re: Custom Color in Measure Without Value List

Hello Scotly,

Open the application in Edit mode and follow given steps:

1. Select the chart and go to the Colors and Legend (Under Appearance tab)

2. Select Custom Colors; Opt for By measure option

3. Click Down Sign Arrow and define a measure. e.g. Sum(CYSales)

This will change the color of chart based on measure value.

Hope this will be helpful.

Regards!

Rahul

abhishek_singla
New Contributor II

Re: Custom Color in Measure Without Value List

Hi Victor,

Without value list, its impossible to apply custom color in a bar char (default qlik object).

I would recommend you to use an EXTENSION.

Here are two extension which might be useful to you:

1. Barplus

2. amCombo

Both extensions will serve your purpose.

Employee
Employee

Re: Custom Color in Measure Without Value List

Hi Scotly,

This can easily be done in Qlik Sense 3.2

Add your measure to the library

Define a color in the edit measure dialog

Color by multicolored and make sure that "Use library measure colors" is on

Multicolor.PNG

Cheers,

Patrik.

ishanbhatt
Contributor II

Re: Custom Color in Measure Without Value List

Hi Scotly,

In Qliksense application there are some limitation to apply our desire colour.

you can follow below listed solutions for your problem.

  1. Use Multicolored  Option and adjust position of the expression. For example set Sum(CYSales) measure as second position and Sum(PYSales) as first position in measure. So it'll solve your problem.                                                Qliksense pass the multicolored sequence Blue,Red,Yellow so as per your requirement set position of the measure.Expression Position.PNG

2.PNG

Don't forgot to set Multicolored option.

2. If Possible then use Extension.

Thanks,

Ishan