Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ravindraa
Creator
Creator

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

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.


1 Solution

Accepted Solutions
anbu1984
Master III
Master III

11 Replies
senpradip007
Specialist III
Specialist III

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.


talk is cheap, supply exceeds demand
ravindraa
Creator
Creator
Author

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
Specialist III
Specialist III

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

ravindraa
Creator
Creator
Author

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
Master III
Master III

Did you try Gysbert's solution below?

ravindraa
Creator
Creator
Author

Hi Anbu Cheliyan,

  i have triedbut Querter value is not gettting.

anbu1984
Master III
Master III

ravindraa
Creator
Creator
Author

Hi Anbu Cheliyan,

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