topic Re: Scatter Chart in QlikView

Scatter Chart

Anonymous — Thu, 27 Mar 2014 19:58:41 GMT

Hi ,

I have a requirement to built a scatter chart

with quarter as x-axis and salesamount as Y axis

Country as dimension ,

we have to use 2 expressions and 1 dimension in creating a scatter chart

Problem I am facing is I want quarter to be displayed as q1, q2,q3 on X axis

Is it possible to create a chart with quarter as x-axis

please find the attached file

Thanks

Re: Scatter Chart

Anonymous — Thu, 27 Mar 2014 20:02:26 GMT

yes it is possible...create a field for quarter and use it as dimension

'Q'&ceil(month(MTH_DATE)/3) as [QuarterNo]

Re: Scatter Chart

maxgro — Thu, 27 Mar 2014 22:11:45 GMT

see attachment

not a scatter

Re: Scatter Chart

Josh_Good — Thu, 27 Mar 2014 23:37:33 GMT

For a scatter plot you need the x and y axis to be numeric. In your data the Quarter are text. A better approach would be to use a line chart and display the points as symbols without a line. If you really really need to use a scatter plot then this can be done by converting the quarters to number. In your case the expression RIGHT([Quarter],1) will work.

-Josh