topic Re: scatter graph for the provided excel sheet in QlikView

scatter graph for the provided excel sheet

Mon, 26 Jan 2026 16:26:21 GMT

Can any one please help me in creating scatter graph for the below attached excel data. the should have x-axiz as A1,A2,A3,........ and so on...y-axis will should have mob,wate.... so on.. same data as in the excel sheet should be on the graph. no need of any aggregation functions. like example A1 to mob has value " ? ". this has to be displayed on the graph. corresponding to x and y axis.

Re: scatter graph for the provided excel sheet

swuehl — Tue, 24 May 2016 09:34:38 GMT

A scatter chart is for using numeric values as axes and plotting a numeric value.

If you want to just show your crosstable, use a pivot table chart.

In the script:

CrossTable(As, Value)

LOAD UTILITIES,

A1,

A2,

A3,

A4,

A5,

A6,

A7,

A8,

A9,

A10,

A11,

A12,

A13,

A14,

A15,

A16,

A17,

A18,

A19,

A20,

A21,

A22,

A23,

A24

FROM

[Book1 (4).xlsx]

(ooxml, embedded labels, table is Sheet1);

Then in the UI, create a pivot table chart with dimensions UTILITIES and As, and =Only(Value) as expression

UTILITIES	As	A1	A2	A3	A4	A5	A6	A7	A8	A9	A10	A11	A12	A13	A14	A15	A16	A17	A18	A19	A20	A21	A22	A23	A24
CCCC		+	+	+	+	?	?	-	-	-	-	-	-	-	?	?	+	+	-	-	-	-	-	-	-
ELE		?	-	-	+	?	-	-	+	?	-	+	-	-	-	?	-	-	+	+	-	?	-	+	-
MOB		?	-	+	-	-	+	?	?	-	-	-	+	?	-	+	-	-	+	+	+	+	-	-	-
SSSS		-	-	?	?	+	+	+	-	-	-	-	-	?	+	+	+	+	+	-	-	-	+	+	+
WATE		-	?	-	-	-	-	-	+	+	+	?	?	?	?	+	+	+	+	-	-	-	-	-	-

Re: scatter graph for the provided excel sheet

Tue, 24 May 2016 09:41:16 GMT

Hi swuel,

Thanks for your reply. there is no chance to plot graph for this? there is no solution for this in nook and corner of qlikView?

Regards

Ranjani.H.Gowda

Re: scatter graph for the provided excel sheet

swuehl — Tue, 24 May 2016 09:53:28 GMT

Maybe if you create underlying numeric values for all your values. But what's wrong with the pivot table chart?

Re: scatter graph for the provided excel sheet

Tue, 24 May 2016 09:57:04 GMT

you mean the table data should be numeric or x and y axis values to be numeric?. our clients needs it in the graph.

Re: scatter graph for the provided excel sheet

swuehl — Tue, 24 May 2016 11:28:47 GMT

Could you upload a sketch of what your client expects and where it differs from a pivot table chart?

Re: scatter graph for the provided excel sheet

Tue, 24 May 2016 11:52:09 GMT

i have put up my requirements in this link [link to not existing topic removed; please just attach the document to your reply]

Re: scatter graph for the provided excel sheet

oknotsen — Tue, 24 May 2016 14:32:17 GMT

Please just post it as an attachment to your reply. The other topic does not exist.

Re: scatter graph for the provided excel sheet

Wed, 25 May 2016 03:55:39 GMT

i am able to attach file in reply. just guide me if you can.

Re: scatter graph for the provided excel sheet

oknotsen — Wed, 25 May 2016 06:50:09 GMT

Click on reply, click on "use advanced editor" in the top-right corner, click on "attach" in the bottom-right corner.

Re: scatter graph for the provided excel sheet

MarcoWedel — Wed, 25 May 2016 14:24:02 GMT

Maybe a grid Chart might be possible.

Re: scatter graph for the provided excel sheet

Thu, 26 May 2016 04:25:31 GMT

Hi Macro,

How is grid chart possible can you please help me.

Re: scatter graph for the provided excel sheet

MarcoWedel — Thu, 26 May 2016 22:25:43 GMT

Hi,

although I think Stefan's solution using a pivot table should fit your requirements best, one solution using a grid chart instead could be:

hope this helps

regards

Marco

Re: scatter graph for the provided excel sheet

Fri, 27 May 2016 04:01:08 GMT

Hi Macro,

Thanks a lot. This is wonderful.

But can you give me steps to do this chart using Qlik view personal desktop.

Re: scatter graph for the provided excel sheet

swuehl — Fri, 27 May 2016 09:38:04 GMT

This looks nice, Marco!

Ranjani, note that a similar coloring and filtering can also be done using the pivot table chart, so it's really beneficial if you can tell us the real customer requirements as I asked for in your other thread:

scatter graph

You should be able to attach files, or at least post screenshots / images using the camera button in the editor tool bar.

To show you what I mean with coloring of a pivot table grid, have a look at

Pivot Table Grids | Qlikview Cookbook

Re: scatter graph for the provided excel sheet

Fri, 27 May 2016 09:47:55 GMT

Hi swuel

I am sorry my costumer requires excatlly way Marco has posted.

I saw the video which you had sent me in other thread but i m not getting use advanced options when i click on reply. that is the reason i could not upload any files

Re: scatter graph for the provided excel sheet

Fri, 27 May 2016 11:09:14 GMT

Hey Marco,

Please reply as soon as possible. Its very urgent. Please tel what have you used in expression as well as in dimension. I am able to get so much. Please tel me what next to do. You can see in the below picture i able to get y-axis but not x-axis. so Please tel me what to do.

Re: scatter graph for the provided excel sheet

swuehl — Fri, 27 May 2016 16:44:55 GMT

     I am sorry my costumer requires excatlly way Marco has posted.



     I saw the video which you had sent me in other thread but i m not getting use advanced options when i click on reply. that is the reason i could not upload any files

Ok, now at least & at last it's clear what your customer requires.

If you read through the very end of the document Sunny has created ('Uploading sample'), it's described that you won't have that advanced editor option from the INBOX.

"Just as a reminder that these options are only available when responding directly on the post. If you are responding from the message inbox from QlikView, you won't see the button for 'Use advanced editor'."

Hence you need to open the thread following the link of the thread, then the advanced editor should be available.

Re: scatter graph for the provided excel sheet

Fri, 27 May 2016 17:25:31 GMT

hi swuel

Yes thats right. i opened it directly from link.

But please can you help me creating the graph whic marco has posted.

Re: scatter graph for the provided excel sheet

Fri, 27 May 2016 17:44:54 GMT

Hi Marco!

This example looks gorgeous!!

Since I have only the Personal Edition , I do not have the permission to open it,

could you be so kind and post how to realize this Grid?.

Im a little newbie on qlik.

Regards!