Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

14 Replies
MarcoWedel

Hi Manish,

one solution could be:

QlikCommunity_Thread_115704_Pic1.JPG.jpg

QlikCommunity_Thread_115704_Pic5.JPG.jpg

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

QlikCommunity_Thread_115704_Pic3.JPG.jpg

QlikCommunity_Thread_115704_Pic4.JPG.jpg

QlikCommunity_Thread_115704_Pic6.JPG.jpg

hope this helps

regards

Marco

Not applicable
Author

Thanks Marco!!

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

Please share the qlikview file.

Thanks

Manish Virmani


MarcoWedel

It's already attached.

Regards

Marco

Not applicable
Author

Printscreen.pngHi 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.

MarcoWedel

Hi,

I erroneously used the wrong dimension.

Here's a new version:

QlikCommunity_Thread_115704_Pic7.JPG.jpg

regards

Marco