Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check this qvw
PFA. Hope it will help.
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.
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.
Could you please upload your qvw in which you are getting trouble to find the right one?
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.
Did you try Gysbert's solution below?
Hi Anbu Cheliyan,
i have triedbut Querter value is not gettting.
Check this qvw
Hi Anbu Cheliyan,
Thank you very much it is working fine for me once again thank you very much.