Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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.