Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
prachi91
Contributor

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

Re: Conditionally background color in bar chart

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

prachi91
Contributor

Re: Conditionally background color in bar chart

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
Valued Contributor II

Re: Conditionally background color in bar chart

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

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

prachi91
Contributor

Re: Conditionally background color in bar chart

It shows only quarter 3 in green color

prachi91
Contributor

Re: Conditionally background color in bar chart

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

mayankraoka
Valued Contributor

Re: Conditionally background color in bar chart

Try This,

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


Regards,

Mayank

prachi91
Contributor

Re: Conditionally background color in bar chart

Already tried.

mayankraoka
Valued Contributor

Re: Conditionally background color in bar chart

If possible please provide sample qvw..

Regards,

Mayank