topic Re: Scatter Chart with Date value in X-Axis in QlikView

Scatter Chart with Date value in X-Axis

Wed, 25 Nov 2020 16:16:04 GMT

I am trying to build a scatter chart (bubble charts) where in dates values are in x-axis and sales values in y-axis. When I create in QV x-axis values shows only numbers. Can someone help me how can I show dates in x-axis? Attach a pic for reference.

Re: Scatter Chart with Date value in X-Axis

Anonymous — Thu, 16 Jun 2016 08:25:41 GMT

For Scatter chart both x and y axis should be expressions, but date is a dimension.

Instead of using Scatter you can go for either Bar or Line chart..

Re: Scatter Chart with Date value in X-Axis

Thu, 16 Jun 2016 08:27:29 GMT

Thanks for the reply...

I can create bar chart.. no issue.

But is there any way to create a chart as mentioned in the pic?

Re: Scatter Chart with Date value in X-Axis

Thu, 16 Jun 2016 08:53:02 GMT

Hello..

I got the solution, we can create a combo chart wherein in the expression tab select Symbols (any symbol as per your choice) and it works perfect.

Thanks for all your support.

Re: Scatter Chart with Date value in X-Axis

prees959 — Mon, 03 Jul 2017 12:14:05 GMT

Hi,

Did you ever find a solution for this?

I too am looking for a way to have a date value on the x-axis....

Re: Scatter Chart with Date value in X-Axis

MarcoWedel — Tue, 04 Jul 2017 22:12:49 GMT

not quite a new thread, but a solution might be:

table1:
LOAD RecNo() as ID,
    Timestamp(Today()-Rand()*10) as Date,
    Ceil(Rand()*100) as Value,
    Ceil((Rand()+0.5)*100) as Momentum
AutoGenerate 30;

hope this helps

regards

Marco

Re: Scatter Chart with Date value in X-Axis

prees959 — Wed, 05 Jul 2017 12:04:13 GMT

Hi Marco,

This really looks like the solution I need - although I can't get it to fit my data. I've attached a sample app where I am trying to achieve this in a GridChart (which probably isn't the best solution). I need the month_year on the x-axis, the minimum cost on the y-axis and the size of the bubble on relating to the QTY purchased...

If you selected 'Gilmour D' as a salesperson, I would like to be able to see an equal spread on the y-axis :

where the values would start on £14 going up in .50 increments £14.00, £14.50, £15.00 upto £19.50....

Is this possible?

Thanks again for any help/advice.

Phil

Re: Scatter Chart with Date value in X-Axis

MarcoWedel — Wed, 05 Jul 2017 21:08:00 GMT

please open a new thread for this grid chart question as this thread is related to scatter charts.

thanks

regards

Marco