topic Re: Scatter Chart with Multiple X-Axis values in QlikView

Scatter Chart with Multiple X-Axis values

mredissi — Sun, 05 Dec 2021 16:34:05 GMT

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

Re: Scatter Chart with Multiple X-Axis values

MarcoWedel — Sun, 05 Dec 2021 20:27:33 GMT

Hi,

maybe like this:

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

Re: Scatter Chart with Multiple X-Axis values

mredissi — Tue, 07 Dec 2021 13:43:14 GMT

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

Re: Scatter Chart with Multiple X-Axis values

MarcoWedel — Tue, 07 Dec 2021 18:20:45 GMT

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:

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

Re: Scatter Chart with Multiple X-Axis values

Marcellus — Sat, 11 Dec 2021 06:34:53 GMT

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

My CC Pay

Re: Scatter Chart with Multiple X-Axis values

mredissi — Wed, 08 Dec 2021 14:13:56 GMT

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

Re: Scatter Chart with Multiple X-Axis values

mredissi — Fri, 10 Dec 2021 14:30:35 GMT

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

Re: Scatter Chart with Multiple X-Axis values

MarcoWedel — Fri, 10 Dec 2021 16:00:48 GMT

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.