topic Re: Multiple values on one day (visualized in chart) in QlikView

Multiple values on one day (visualized in chart)

roelvandeven — Wed, 25 Sep 2013 12:27:36 GMT

I hope someone can help.

I'm trying to visualize a set of measurements into a graph, so it shows me all values on one day without having to Sum( or Avg( them. So a point for every measurement on that day. At the moment I can't seem to get it to work.

In Excel however it's very easy, so I would think QV could handle it as well.

I used the date as Dimension

The measurement value as Expression (so: =Measurement)

Re: Multiple values on one day (visualized in chart)

Oleg_Troyansky — Wed, 25 Sep 2013 20:16:13 GMT

You have a choice of 2 or even 3 charts, and your choice of Dimensions and Expressions will depend on the object:

1. Grid chart - 2 dimensions, 1 expression:

Dim1 = Date

Dim2 = Measurement

Expression = ? Maybe a simple 1 ?

2. Scatter chart - 1 Dimension, 2 Expressions

Dimension - any kind of a unique ID identifying every detailed row of the data.

Expr1 (X) - only(Date)

Expr2 (Y) - only(Measurement)

3. Line (symbol) Chart - 2 Dimensions, 1 expression (I'm not totally sure about it):

Dim1 = Date

Dim2 = Unique ID

Expr. = only(Measurement)

Uncheck "Line" and only use "Symbol" for the expression.

one of those 3 options should give you the desired result.

cheers,

Oleg Troyansky

www.masterssummit.com

Re: Multiple values on one day (visualized in chart)

roelvandeven — Thu, 26 Sep 2013 07:25:56 GMT

Hi Oleg,

Thank you very much!!

The first option worked best for me.