Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Florent32
Contributor II
Contributor II

Color on 3 Last month

Hello,

 

I have an Histogram with 3 value calculated.

Month -3 / Month -2 / Last month

 

I want to have a color different on each month.

I have try 

If (addMonth(today(), -1), '#505468',

     (If (addMonth(today(), -2), '#308523')

Or 

If (MasterDate.autoCalendar.month =-1, '#505468',

     (If (MasterDate.autoCalendar.month =-2, '#308523')

But it's does not works

Could you please help me?

 

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

To achieve it, i suggest you to create a master measure for each one of the three measures, there you can also set a specific color.

View solution in original post

7 Replies
Saravanan_Desingh

Have u tried, Multicolored under Colors?

Multicolored.PNG

Florent32
Contributor II
Contributor II
Author

Hi,

Thanks for your reply.

I have to specified specific color code (client company color) so no possibility to use multicolor option...

Do you have an other idea? 🙂

agigliotti
Partner - Champion
Partner - Champion

Hi @Florent32 ,

Which are your actual bar chart measure and dimension ?

Florent32
Contributor II
Contributor II
Author

Hello,

Chart representation below

Florent32_0-1616143392466.png

I hope it's more clear,

Br,

Florent

Florent32
Contributor II
Contributor II
Author

Dimension: Lot

Measures: Month -3 / Month -2 / Last month

agigliotti
Partner - Champion
Partner - Champion

To achieve it, i suggest you to create a master measure for each one of the three measures, there you can also set a specific color.

Florent32
Contributor II
Contributor II
Author

Thanks for the answer !

Have a good day!