Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 

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


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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
1 Reply
Not applicable


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