topic Re: Show all value on time chart in QlikView

Show all value on time chart

Anonymous — Mon, 20 Jul 2015 12:21:00 GMT

I feel short of one function to built one chart, but maybe im wrong and with your help i can built it.

I have time axis (X) and many records (example sales data)- many values for one day.

I want chart that show literally all values- not only min/max/avg calculated from those records but kind of scatter plot showing whole range of data.

Example

http://1.bp.blogspot.com/-Gksq0YHiOxM/TkxBXOw9bfI/AAAAAAAAAA4/jWaqHjRKed8/s1600/ScatterPlotFigure2.png

thanks in advace

Re: Show all value on time chart

maxgro — Mon, 20 Jul 2015 21:20:22 GMT

like this?

PFA

Re: Show all value on time chart

Anonymous — Tue, 21 Jul 2015 07:22:40 GMT

Exactly like this!

Unfortunetely I have license for one author and I cannot (yet) open qvw files made by someone else. Could you put here screens of expression and dimension of this chart, please? I would really appreciate.

Re: Show all value on time chart

maxgro — Tue, 21 Jul 2015 11:20:52 GMT

load

ROWNO() AS id,

time(frac(makedate(2015) + floor(rand()*210*1) + floor(rand()*24, 1/24))) as time,

floor(rand()*100) as amount

AutoGenerate 100;

chart is a scatter with

dimension id

expression time (backgroun color ...), formatted as time in number tab hh:mm

amount

Re: Show all value on time chart

Anonymous — Tue, 21 Jul 2015 12:23:30 GMT

Ok. Thanks. But what if my date dimension is text label, not a numer? And "Expression default" as Number format expression doesn't help at all.

When I use my time dimension as dimension there is no problem, but here I need to use it as expression.