topic Re: OrderNumber in a chart in QlikView

OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 14:55:55 GMT

Hi,

There is a chart where any set of brands may be displayed

For each brand in this particular chart I'd like to calculate an OrderNumber and according to this order number set a color using a Color function.

I tried this formular:

color(RowNo())

It fails to work correctly for my chart, maybe, it is because my chart is rather complicated.

Is there any other way to calculate an OrderNumber in a chart?

Thank you in advance,

Larisa

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 15:36:54 GMT

Not sure I understand the requirement? Would you be able to share some data to help understand the requirement?

Best,

Sunny

Re: OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 16:03:00 GMT

I'd like this chart to be multicolured. This chart is based on a complicated formula. I'd like the formula to remain as it is.

So I need to set a certain colour for each bar. I'd like to take colours from a color pallete.

But if I set Color(RowNo()) in chart settings as a Background Color it distroys my formula.

I suppose that it is because of the function RowNo(). Maybe, there is some alternative.

See the file attached.

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 16:08:52 GMT

Try this expression:

=Pick(RowNo(), Red(), Green(), Blue(), Yellow(), LightBlue(), LightCyan(), LightGray(), LightGreen(), LightMagenta(), LightRed())

.Output:

Re: OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 16:23:48 GMT

I see a different output. See the file attached.

I can I get a correct result?

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 16:25:35 GMT

Did you look at the attacted qvw? Re-attaching it with this post check it out or post your new qvw.

Best,

Sunny !

Re: OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 16:31:55 GMT

Yes,

I opened your file and saw a different output.

I reattach the file.

Larisa

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 16:36:58 GMT

Lairsa -

I am not sure why it is doing that. Can you try opening this one to check if it is still doing the same thing?? Alternatively what happens when you add =Pick(RowNo(), Red(), Green(), Blue(), Yellow(), LightBlue(), LightCyan(), LightGray(), LightGreen(), LightMagenta(), LightRed()) as Background color to your own version you added here (not the one I sent). Does it still do the same thing?

Best,

Sunny

Re: OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 16:43:31 GMT

Sunny,

It's all the same. I see the same result in your file and in my own file (see the file attached). It seems strange that we get different results.

I'm using SR2. I can not switch to a later version.

Regards,

Larisa

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 16:47:08 GMT

I am using SR10, but I am not sure if the version difference is causing this. The reason I say this is because we are using some very simple functions which should not have changed over the previous versions. But having said that, we are seeing different outputs and not sure how we can handle this unless I can replicate the same issue at my end.

Let me still see if I can work on another solution for you.

Best,

Sunny

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 16:48:07 GMT

Can you send a screenshot of what happens when you convert the above into a straight table?

Re: OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 16:52:13 GMT

See the file attached.

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 16:53:21 GMT

I see the problem now. Let me fix it and resend it in a bit.

Best,

Sunny

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 16:57:44 GMT

Can you try it now?

Re: OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 17:20:50 GMT

Thank you, it works!

Is Aggregated Dimension the only solution?

The point is that I would not like to use an Aggregated Dimension if possible.

larisa

Re: OrderNumber in a chart

sunny_talwar — Wed, 03 Jun 2015 17:24:32 GMT

We did try the other option, which wasn't working for you (for some reason). I don't know a third way to do it just on the front end of the application. I can suggest you a back end way, but that won't be dynamic based on your selection which won't be very useful in your case.

Best,

Sunny

Re: OrderNumber in a chart

Anonymous — Wed, 03 Jun 2015 17:32:47 GMT

Thanks, Sunny!