topic Scatter Chart in QlikView

Scatter Chart

jagan — Tue, 08 Nov 2011 09:19:29 GMT

Hi,

I need to create a Scatter / Bubble chart. Such that the dimension should be Salesman, X axis should be Month, Y axis should be Sales and Bubble size should be (Sales/No. of Products). I am trying to display the month(in the format of Month-Year) in the X axis, but I am getting numeric values.

Is this possible in Scatter chart?

Regards,

Jagan.

Scatter Chart

kji — Tue, 08 Nov 2011 11:03:55 GMT

Scatter chart will use numeric values on the axes (Discrete axis version is Grid chart), you should be able to set the number format to a date format to get that on the axis.

Scatter Chart

Anonymous — Tue, 22 Nov 2011 17:38:39 GMT

Use the monthname() function

Scatter Chart

jagan — Wed, 23 Nov 2011 05:30:04 GMT

Tried it, but it is displaying in Numbers.

Regards,

Jagan.

Scatter Chart

Wed, 23 Nov 2011 05:37:54 GMT

I guess your xAxis expression is Month and not sum(Month). If its Month, go to number format and select it as date and give the format MMM-YY

Regards,

Kiran.

Scatter Chart

jagan — Wed, 23 Nov 2011 06:05:59 GMT

Tried it, but of no use. Also posted this as an Idea

http://community.qlik.com/ideas/2116

Regards,

Jagan.

Scatter Chart

Wed, 23 Nov 2011 06:23:40 GMT

You can get this may be using grid chart. Have month as dimension 1, aggr(month,salesman and sales) as dimension 2, salesman as dimension 3.

This may be close to what you need.

Scatter Chart

jagan — Wed, 23 Nov 2011 08:54:53 GMT

Since, my data has hunderds of Salesman, the grid chart is not suitable for this scenario.

Regards,

Jagan.