Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnuchinni
Creator III
Creator III

Selected month should be highlighted in Graph section

Selected month should be highlighted in Graph section::



Hi friends,


Need help on this is very urgent


I have a Combo chart with MOnth as Dimension.

when am select the any of month that month name should be highlighted in one color.


for example if i will select the Jan, Jan should be display in Yellow on Chart.


Many Thanks In advance



Regards

Praveen

11 Replies
jmvilaplanap
Specialist
Specialist

Hi

You can use a trigger when a field is selected, changing the value of a variable (this variable has the colour of you want).

But I don't know if this runs in Access Point, but for sure in the Qlikview Client App.

Regards

mdmukramali
Specialist III
Specialist III

Dear Praveen,

long back I had same requirement I achieved it by following a blog from QVDesign.

kindly find the attached sample application.

271076.PNG

kindly find the attached application with sample data.

Thanks,

Mukram.

chinnuchinni
Creator III
Creator III
Author

is it possible to change the dimension color . eg: oct 2015

and please provide me the logic where i have to apply because i cannot open  this attachment application in office .

mdmukramali
Specialist III
Specialist III

Dear Praveen,

is it possible to change the dimension color . eg: oct 2015

Yes it's possible to change the color .


and please provide me the logic where i have to apply because i cannot open  this attachment application in office .

In the chart properties :

Expression tab , Expand the Expression in background apply the following formula,


=if(GetPossibleCount(MonthYear)<>Count({1}DISTINCT TOTAL MonthYear),

if(Match(MonthYear,Concat(DISTINCT MonthYear,',')),Yellow(),RGB(140,170,203)))



6.PNG




Thanks,

Mukram.

chinnuchinni
Creator III
Creator III
Author

i need to display OCT 2015 in color ,am not talking about Bar.

mdmukramali
Specialist III
Specialist III

Dear Praveen,

i need to display OCT 2015 in color ,am not talking about Bar.

ok .

here you go.

you have to add another expression :MonthYear = ONLY({1}MonthYear)


Text Color : 

=if(GetPossibleCount(MonthYear)>=1,

      if(Match(MonthYear,Concat(DISTINCT MonthYear,',')),Yellow(),Black()))

8.PNG

7.PNG

chinnuchinni
Creator III
Creator III
Author

hi mukram,

am getting MOnth - Year two times at x-axis position, how can i resolve it ?

please help me this

Regards

Praveen

passionate
Specialist
Specialist

HI Praveen,

You need to disable display option by unchecking bar checkbox of second expression.

Regards,

Pankaj

chinnuchinni
Creator III
Creator III
Author

yah i did that one,and enable the text on axis