topic Days Grouping having problem with legend colors in QlikView

Days Grouping having problem with legend colors

Thu, 05 Dec 2013 13:43:10 GMT

Hi Everyone ,

Little bit about my chart functionality:

My chart has count of faults (e.g. F1,F2 etc) are grouped over X-Axis like this 0,1,2,3,4+ , Then there is a filter of how much days(days are also grouped) faulty product remained in store. Secondary dimension defines selected days groups as positive(+) and other than those as negative(-). Y-Axis gives count of faulty products.

Now come to the problem which I am facing:

When I select <60 days in filter legend colors gets change, whereas any other selection give right color to legends , as you can see in below screen shots.

Correct Colors:

Incorrect Colors:

Can anybody explain why colors gets inverted in 0-60 Day Grouping??? One guess may be if you delete second expression then everything goes fine. But I cant delete this second expression.

I also have attached qlikview application file and data file

Any help will be highly appreciated.

Message was edited by: Mubbasher Khaliq Because previously attached version was wrong so I have attached correct versions. One more thing which I found is that if I remove second expression from chart "Point Values" then everything is fine, I am using second expression to reveal hide count.

Re: Days Grouping having problem with legend colors

Thu, 05 Dec 2013 13:52:27 GMT

uncheck "persistant color"

best regards

chris

Re: Re: Days Grouping having problem with legend colors

Fri, 06 Dec 2013 12:20:00 GMT

Hi Juillard ,

Sorry last time I attached the wrong version, Now I have updated the post + correct attachments. One possible reason is second expression which I am using to show/hide count and first expression value on top of chart bars. If I remove this second expression then everything goes fine... But I cant delete this second expression...

Regards:

Mubbasher Khaliq

Re: Days Grouping having problem with legend colors

Fri, 06 Dec 2013 13:55:16 GMT

Hi Mubbasher

copy this as background color

if(left($(v_store_days_dimension), 1)='+', blue(), red())

it works well

best regards

chris

Re: Re: Days Grouping having problem with legend colors

Sun, 08 Dec 2013 09:43:00 GMT

Hi Juillard ,

It works well only when only single store day range is selected , If you select all or clear all then you will see single color goes to each legend. Also legends are getting gradient colors, Is there any other way to do the same thing.

Regards:

Mubbasher