Scatter Chart

[jagan]

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.

[kji]

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.

[Anonymous]

Use the monthname() function

[jagan]

Tried it, but it is displaying in Numbers.

Regards,

Jagan.

[#5]

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.

[jagan]

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

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

Regards,

Jagan.

[#7]

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.

[jagan]

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

Regards,

Jagan.