topic Re: Conditionally background color in bar chart in QlikView

Conditionally background color in bar chart

Anonymous — Wed, 11 Jul 2018 11:28:51 GMT

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.

Re: Conditionally background color in bar chart

vishsaggi — Wed, 11 Jul 2018 11:43:49 GMT

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

Re: Conditionally background color in bar chart

Anonymous — Wed, 11 Jul 2018 11:54:46 GMT

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.

Re: Conditionally background color in bar chart

sergio0592 — Wed, 11 Jul 2018 11:57:05 GMT

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

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

Re: Conditionally background color in bar chart

Anonymous — Wed, 11 Jul 2018 12:03:44 GMT

It shows only quarter 3 in green color

Re: Conditionally background color in bar chart

Anonymous — Wed, 11 Jul 2018 12:22:51 GMT

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

Re: Conditionally background color in bar chart

mayankraoka — Wed, 11 Jul 2018 12:26:06 GMT

Try This,

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

Regards,

Mayank

Re: Conditionally background color in bar chart

Anonymous — Wed, 11 Jul 2018 12:31:59 GMT

Already tried.

Re: Conditionally background color in bar chart

mayankraoka — Wed, 11 Jul 2018 12:39:48 GMT

If possible please provide sample qvw..

Regards,

Mayank