topic Re: Color Based on Specific Date/Month Range/Period in QlikView

Re: Color Based on Specific Date/Month Range/Period

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

May be this?

Create Line Chart

Dimension as DateField

And Expression should be this? If you want label you can give label as GDPRange

Sum({< DateField = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} GDPValue)

And, Back ground expression may be this

If(GDPRange, Red(), Green())

If(Sum({< DateField = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} GDPValue), Red(), Green())

Re: Color Based on Specific Date/Month Range/Period

Mon, 15 May 2017 12:00:08 GMT

Hi,

Thanks for reply. I tried to replicate, But its not working. I am adding here my example file.

What I want are:-

1) Based on input dates, GDP should not change

2) Based on input dates, online highlights the GDP with different color.

E.g, if I input dates only those parts change to some other color, but at the same time line chart remain plotted for complete year. Please look into image. Once again, Thanks in advance