Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditionally background color in bar chart

Hello everyone,

I need to show quarterly color. For coming quarters it becomes blue and for past quarters it becomes green.

I tried more times but still not getting any solution.

Please help me to find out.

Thanks.

8 Replies
vishsaggi
Champion III
Champion III

Can you share some more information or sample data to look into?

Anonymous
Not applicable
Author

Suppose I have 2017,2018,2019 years of data. So when I select year 2017 then all quarters in green color, if I select 2018 then quarter 1 in green and rest of the in blue color.

sergio0592
Specialist III
Specialist III

Hi, and if you try as background color expression with :

if(QuarterName(Date)=QuarterName(today()),green(),blue())

Anonymous
Not applicable
Author

It shows only quarter 3 in green color

Anonymous
Not applicable
Author

2019 data should be in green. I need show past quarters in blue and future & presnpr quarters in green

mayankraoka
Specialist
Specialist

Try This,

if(QuarterName(Date)<QuarterName(today()),blue(),green())


Regards,

Mayank

Anonymous
Not applicable
Author

Already tried.

mayankraoka
Specialist
Specialist

If possible please provide sample qvw..

Regards,

Mayank