Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stonecold111
Contributor

Qliksense

I have 3 expressions

I need to apply colors by expression

Eg:  3 expressions

Sales

Quantity

Amount

In bar chart

If it is sales - green

Amount- red

Quantity- blue

Expression by color?

Tags (1)
1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Qliksense

Create Master Measures shown in figures. there in Create Master Measure Window you will get option to assign color.

Use this Master Measures in Charts.

In Chart's Appearance Section, -> Colors -> you will get option to choose Library Colors

8 Replies
shraddha_g
Honored Contributor III

Re: Qliksense

create these 3 Measures in Master Item. While Creating you will get a option to assign color to each expression

sureshqv
Esteemed Contributor III

Re: Qliksense

in colours tab try by meausre?

stonecold111
Contributor

Re: Qliksense

How you write in

Color by expression

shraddha_g
Honored Contributor III

Re: Qliksense

In Color by expression you cant refer to measures Labels

stonecold111
Contributor

Re: Qliksense

Yes I know that.

But how to write. I don't have any field for those expression s

So I can't use pick(match

stonecold111
Contributor

Re: Qliksense

Let's consider

3 expressions

Sum(sales). - sales

Sum(quantity)-quantity

Sum(amount)-amount

agigliotti
Honored Contributor II

Re: Qliksense

you have to set Auto as Colors in the bar chart because the color for each measure is specified in master items.

shraddha_g
Honored Contributor III

Re: Qliksense

Create Master Measures shown in figures. there in Create Master Measure Window you will get option to assign color.

Use this Master Measures in Charts.

In Chart's Appearance Section, -> Colors -> you will get option to choose Library Colors