Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show all value on time chart

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.p...

thanks in advace

1 Solution

Accepted Solutions
maxgro
MVP
MVP

4 Replies
maxgro
MVP
MVP

like this?

PFA

1.png

Anonymous
Not applicable
Author

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.

maxgro
MVP
MVP

a:

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

1.png

Anonymous
Not applicable
Author

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.