topic Re: Line Chart in QlikView

Line Chart

Wed, 19 Nov 2014 12:52:21 GMT

I have a table like this:

Date	Value	Precision
10.11.2012	10	0.1
11.11.2012	15	0.2
11.11.2012	20	0.15
11.11.2012	10	0.1
12.11.2012	20	0.2
12.11.2012	15	0.3

I would like to build a line chart which would have dates on the x-axis and values at y-axis. It should display values for each date. The problem is having multiple values on a single day. How can we dispay all values for each day?

Re: Line Chart

Wed, 19 Nov 2014 13:18:23 GMT

hello,

I believe that if you put the DATE dimension and expression to put COUNT (VALUE) and COUNT (PRECISION) will work.

Re: Line Chart

maleksafa — Wed, 19 Nov 2014 13:21:24 GMT

you need to use sum or other aggregation function on the value field.

Re: Line Chart

jagan — Wed, 19 Nov 2014 13:26:33 GMT

HI,

Try like this, you need to use aggregation function Sum(), Max() or Min() as per the requirement.

Dimension : Date

Expression: Sum(Value)

Hope this helps you.

Regards,

Jagan.

Re: Line Chart

Wed, 19 Nov 2014 13:41:15 GMT

But this will give me the sum of values for each day. I want to display all the values instead of displaying the sum or average of those values.

Re: Line Chart

jagan — Wed, 19 Nov 2014 13:49:14 GMT

Hi,

Generally in chart the expression need to use some of the aggregation functions, otherwise if there are multiple values for the same dimension value then you will get the null value for that dimension, to overcome this you need to differentiate each dimension value like below

LOAD

Date(Num(Date) + RecNo()/1000) AS Key,

Date,

Value

FROM DataSource;

Now use Key in dimension and value as expression, now you will get all the values.

Hope this helps you.

Regards,

Jagan.