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

[#1]

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.

[#2]

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

[#3]

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

[Clever_Anjos]

Maybe this?

[#5]

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

[#6]

Hi Clever Anjos

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

Thanks

Manish Virmani

[#7]

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

[#8]

You can group dimensions into cyclic groups or hierarchy groups.

regards

Darek

[Clever_Anjos]

Not using scatter chart,

One work around is using some variable to change the expression

[Clever_Anjos]

PFA an example