topic Re: How to change color for all data points based upon a rule? in QlikView

How to change color for all data points based upon a rule?

Mon, 08 Apr 2013 21:27:05 GMT

Hi Experts,

I tried to change colors for the data points meeting a rule - three of four continuous points on one line are higher than those on another line. Right now the color was only changed on the first data point. Not sure why. Please refer to the file in the attachment.

Thanks

Longmatch

Re: How to change color for all data points based upon a rule?

Anonymous — Mon, 08 Apr 2013 22:23:30 GMT

as the graph you okay, really this just changing color if 3 of the 4 points are higher. But the expression is evaluated points from right to left. to evaluate from left to right should be BEFORE the function.

Try putting
if (rangesum (below (if (% Data>% R, 1, 0), 0,4))> = 2, Black (), Yellow ())

The expression is fine.

Re: How to change color for all data points based upon a rule?

Tue, 09 Apr 2013 02:37:32 GMT

Check this blog. Hope this helps you to solve.

Re: How to change color for all data points based upon a rule?

Tue, 09 Apr 2013 04:21:27 GMT

Tried your solution, no luck. There is still one data point colored in black.