Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

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

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())

Or

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
1 Reply
Not applicable

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

Capture-111.PNG