Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Dear Praveen,
long back I had same requirement I achieved it by following a blog from QVDesign.
kindly find the attached sample application.
kindly find the attached application with sample data.
Thanks,
Mukram.
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 .
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)))
Thanks,
Mukram.
i need to display OCT 2015 in color ,am not talking about Bar.
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()))
hi mukram,
am getting MOnth - Year two times at x-axis position, how can i resolve it ?
please help me this
Regards
Praveen
HI Praveen,
You need to disable display option by unchecking bar checkbox of second expression.
Regards,
Pankaj
yah i did that one,and enable the text on axis