topic Re: Help required to create x y scatter chart with multiple dimension in QlikView

Help required to create scatter chart with multiple dimension excel file attached

Sat, 26 Apr 2014 15:43:52 GMT

Hi All,

I am a bit confused and required your help to create a X Y Scatter chart.In the X axis we have to show 4 team and in Y axis we have to show 3 fields.Excel attached for the example. Please suggest the solutions.

Re: Help required to create x y scatter chart with multiple dimension

Sat, 26 Apr 2014 18:11:40 GMT

You have many possibilities to configure this kind of chart. You can use color or shape (symbol) to show additional dimension information. You can even use pie as your bubbles to show for example how total value is divided for some components.

If you dont have idea how your chart should look like good idea may be to look on examples on demo site.

regards

Darek

Re: Help required to create x y scatter chart with multiple dimension

Sat, 26 Apr 2014 18:19:44 GMT

Thanks Dariusz for your reply

please see the attached excle file, i need to replicate this in qlikview. It would be helpful if you can share some links where related solution is provided.

Thanks

Manish Virmani

Re: Help required to create x y scatter chart with multiple dimension

Clever_Anjos — Sat, 26 Apr 2014 18:27:33 GMT

Maybe this?

Re: Help required to create x y scatter chart with multiple dimension

Sat, 26 Apr 2014 18:36:03 GMT

Hi Clever Anjos

Thank you!!

On the Y axis we wants to show sales, sales growth and share growth, is that possible.

Thanks

Manish Virmani

Re: Help required to create x y scatter chart with multiple dimension

Sat, 26 Apr 2014 19:32:16 GMT

Hi Clever Anjos

I am trying to say at a time can we select sales or sales growth or share growth.

Thanks

Manish Virmani

Re: Help required to create x y scatter chart with multiple dimension

Sat, 26 Apr 2014 19:47:07 GMT

Hi All,

Can we achieve multiple field in y axis using grouping in qlikview. I am not sure if by grouping can we able to select one particulat field at a time?

Thanks

Manish Virmani

Re: Help required to create x y scatter chart with multiple dimension

Sat, 26 Apr 2014 20:16:14 GMT

You can group dimensions into cyclic groups or hierarchy groups.

regards

Darek

Re: Help required to create x y scatter chart with multiple dimension

Clever_Anjos — Sat, 26 Apr 2014 23:51:45 GMT

Not using scatter chart,

One work around is using some variable to change the expression

Re: Re: Help required to create x y scatter chart with multiple dimension

Clever_Anjos — Sat, 26 Apr 2014 23:57:31 GMT

PFA an example

Re: Help required to create scatter chart with multiple dimension excel file attached

MarcoWedel — Sun, 27 Apr 2014 01:41:50 GMT

Hi Manish,

one solution could be:

You can use expression grouping instead of dimension grouping in this case

hope this helps

regards

Marco

Re: Help required to create scatter chart with multiple dimension excel file attached

Sun, 27 Apr 2014 06:36:48 GMT

Thanks Marco!!

Yes, i am looking for this type of solution. This is great.

Please share the qlikview file.

Thanks

Manish Virmani

Re: Help required to create scatter chart with multiple dimension excel file attached

MarcoWedel — Sun, 27 Apr 2014 08:32:46 GMT

It's already attached.

Regards

Marco

Re: Help required to create scatter chart with multiple dimension excel file attached

Sun, 27 Apr 2014 14:17:41 GMT

Hi Marco,

Please let me know when I selecting team B and taking cursor to bubble, it is showing value of Team A and Team B. Shouldn't it should show team B, because I have selected teamB.

Re: Re: Help required to create scatter chart with multiple dimension excel file attached

MarcoWedel — Sun, 27 Apr 2014 21:10:29 GMT

Hi,

I erroneously used the wrong dimension.

Here's a new version:

regards

Marco