topic Re: Problem with Scatter chart in QlikView

Problem with Scatter chart

Fri, 02 Aug 2013 11:39:23 GMT

Hello all,

I want to create a scatter chart but I am facing lots of difficulties. I have some age ranges of our customers (20-30,30-40,40-50 etc) and I want to see in a scatter chart, all of those purchases in terms of Price amount. For example, by the 1-1-2013, 1000 purchases have happened. I want to see 1000 dots in a chart, where every dot will have a color that represents the age range, the X-axis will be amount of purchase and the Y-axis will be the time.

This way, I want to see, which are the price gatherings in the different age ranges cross time.

I have done everything, please help me a little bit.

I have attached an example I have found that looks like the one I want to create.

Thanks

Re: Problem with Scatter chart

Gysbert_Wassenaar — Fri, 02 Aug 2013 12:35:11 GMT

Add purchase_id (?) as first dimension and the age rage as second dimension. On the presentation tab choose Only Symbols as Representation so only dots will be shown and no lines between dots.

Re: Problem with Scatter chart

Fri, 02 Aug 2013 13:25:34 GMT

Thanks for your reply. What about the expressions?

Re: Problem with Scatter chart

Fri, 02 Aug 2013 13:39:21 GMT

In the Y-Axis I want to put the amount of money and in the X-Axis I want to put time.

I am trying with Date or day(Date) or month(Date) but it doesn't work for some reason. You can see below what I get back.