Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Line Chart with Two Dimensions & Two Expressions

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)

Sales by Group.JPG

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.

Sales by Group w Target.JPG

It seems that Expr_1 is now ignoring the second dimension.

2 Replies
Not applicable
Author

In line chart its not possible on this case.

you can use Grid chart    

Karthik

Anonymous
Not applicable
Author

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.