How to display the last 7 months different color in line chart

[ravindraa]

Hi all,

  I have one requierment that i need to display latest 7 months data with different color as well as latest 2 Quarter also

i have created two charts one for year month and second one yearQuarter but i am not getting different color for latest 7 month and 2 Quarters data.

i have attached sample files please find those.

I need to display the values like below screen shot.

please give me any suggesion on this issue.

Thanks in advance.

[senpradip007]

PFA. Hope it will help.

[Gysbert_Wassenaar]

Try =IF(YearMonth >= addmonths($(=num(max(YearMonth))),-7), RGB(255,255,0), RGB(0,215,0))

The quarters you'll first have to turn into dates. Otherwise the max function can't be used. It won't work well on text values.

[ravindraa]

Hi Pradip Sen,

   i am getting first values color changes but i need latest months and quearter values color need to change,

please give me suggesion.

thanks in advance.

[senpradip007]

Could you please upload your qvw in which you are getting trouble to find the right one?

[ravindraa]

Hi Pradip Sen,

  Which ever you have posted application that one also giving the first values not giving the latest values,

please give me any suggsion.

Thaks in advance.

[anbu1984]

Did you try Gysbert's solution below?

[ravindraa]

Hi Anbu Cheliyan,

  i have triedbut Querter value is not gettting.

[anbu1984 · Accepted solution]

Check this qvw

[ravindraa]

Hi Anbu Cheliyan,

   Thank you very much it is working fine for me once again thank you very much.