Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
mredissi
Contributor II
Contributor II

Scatter Chart with Multiple X-Axis values

I have 2 sets of data that I need to chart using scatter chart. The only problem is the X-Axis values are different for the 2 sets of data. How can I specify different X-Axis for each Y-Axis data? I appreciate your help. Thanks

mredissi_0-1638721942537.png

 

1 Solution

Accepted Solutions
mredissi
Contributor II
Contributor II
Author

Thank you very much again Marco. I will definitely try this method. Cheers!

View solution in original post

7 Replies
MarcoWedel

Hi,

maybe like this:

 

MarcoWedel_0-1638736002207.png

 

MarcoWedel_1-1638736011261.png

 

MarcoWedel_2-1638736021501.png

 

MarcoWedel_3-1638736031720.png

 

 

table1:
LOAD RowNo()	as ID,
     X_Axis1	as X_Axis,
     Y_Axis1	as Y_Axis,
     1			as Axis
FROM [https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/1216361/1/ScatterChart.xlsx] (ooxml, embedded labels, table is Sheet1);


LOAD RowNo()	as ID,
     X_Axis2	as X_Axis,
     Y_Axis2	as Y_Axis,
     2			as Axis
FROM [https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/1216361/1/ScatterChart.xlsx] (ooxml, embedded labels, table is Sheet1);

 

hope this helps

Marco

mredissi
Contributor II
Contributor II
Author

Thank you very much Marco. This will work for a simple charts as you demonstrated but I have other cases where I needed to chart 2 families of curves as shown next. I'm attaching a sample data file if you could please help with. Thanks

  

mredissi_0-1638884475246.png

 

MarcoWedel

I still would go for a data model solution, combining all different x and y fields into one single pair x and y plus an additional column to name the origin of this data.

One pure front end solution without changing the table structure of your sample data however could be:

 

 

MarcoWedel_0-1638901120447.png

 

MarcoWedel_1-1638901142238.png

 

MarcoWedel_2-1638901157605.png

 

MarcoWedel_3-1638901169377.png

 

table1:
LOAD RowNo()	as ID,
     X1, 
     Y1, 
     Y2, 
     Y3,
     X2, 
     Min, 
     Base, 
     Max
FROM [https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/1216387/1/Scatter2.xlsx] (ooxml, embedded labels, table is Sheet1);

 

 

hope this helps

Marco

 

 

Marcellus
Contributor
Contributor

Thank you for sharing Scatter Chart with Multiple X-Axis values.

 

My CC Pay

mredissi
Contributor II
Contributor II
Author

Thank you very much again Marco. I will definitely try this method. Cheers!

mredissi
Contributor II
Contributor II
Author

Hello Marco,

I was wondering if you could please suggest a different solution if the data comes from separate files. How would set up the scatter chart in that case? I'm attaching the same data but split in 2 files and we want to plot them using different X axis on the same scatter chart. Thanks in advance

MarcoWedel

I feel this might be a different question as this is rather about defining a data model based on your business logic, which is not obvious from your sample data.