Days Grouping having problem with legend colors

[#1]

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.

[#2]

Hi

uncheck "persistant color"

best regards

chris

[#3]

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

[#4]

Hi Mubbasher

copy this as background color

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

it works well

best regards

chris

[#5]

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