topic Re: Scatter Plot with Dates in QlikView

Scatter Plot with Dates

Wed, 13 Jan 2016 18:21:43 GMT

I am starting to suspect that I cannot use dates in the X (or y) axis on a scatter plot. It looks like Qlikview is expecting it to be an integer.

Is this true and if not how is this possible?

I am currently working around the issue by tagging my data points with a numeric representation of the date value and then using that in the axis.

When I attempt to use the actual date it is not reacting as I would like.

Re: Scatter Plot with Dates

swuehl — Wed, 13 Jan 2016 19:24:06 GMT

I think it should work, if your dates are interpreted as such, i.e. they show a numeric representation (dual values).

What do you see if you are using dates (what is the issue you see)?

Re: Scatter Plot with Dates

Wed, 13 Jan 2016 19:52:47 GMT

That's what I thought it should do . However when I attempt to use the dates directly the x axis goes to various years and drops my data points into one spot.

My data points are for several hours across a few day span but for some reason the axis defaults to years.

Thinking there may be something I can change in the properties to get this to work right but not sure what it is.

Re: Scatter Plot with Dates

swuehl — Wed, 13 Jan 2016 21:48:57 GMT

I remember I ran into this issues as well some time ago. I think I've handled this by setting the static min / max on axes tab (you can use expressions for static min / max to keep it dynamic to your data range).

Re: Scatter Plot with Dates

MarcoWedel — Thu, 14 Jan 2016 23:00:04 GMT

Hi,

to change the default behaviour from

you can also deselect the "forced 0" option of the x-Axis and set the number format to timestamp:

hope this helps

regards

Marco