topic Re: Line Chart with Two Dimensions & Two Expressions in QlikView

Line Chart with Two Dimensions & Two Expressions

Anonymous — Fri, 14 Jun 2013 22:33:21 GMT

I've read elsewhere in the community that you can't have a line chart that has two dimensions and two expressions. Is this true? If so, is there a workaround?

I can create a line chart that looks good with

Dim_1 = Sales_Group
Dim_2 = Employee_ID
Expr_1 = AVG(Sales)

But when I try to add a second expression (Expr_2 = AVG(Sales_Target)), Qlikview automatically aggregates the individual black dots that represent each employee's sales into a single dot.

It seems that Expr_1 is now ignoring the second dimension.

Re: Line Chart with Two Dimensions & Two Expressions

Sat, 15 Jun 2013 06:47:38 GMT

In line chart its not possible on this case.

you can use Grid chart

Karthik

Re: Line Chart with Two Dimensions & Two Expressions

Anonymous — Mon, 17 Jun 2013 14:53:35 GMT

Is there a way for a grid chart to show a dot for each employee (like in the first chart above)? And then can I add another expression that plots a line? This is what I need.