Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Foodie123
Contributor III
Contributor III

Line Chart: How to show all expressions all at once in a line chart?

Hello Experts,

I am trying to show 4 different lines in a line chart but only 2 of them are showing at a time. How do I show all 4 lines all at once in a line chart? The line chart  does output the data correctly based on the selections I make.

My chart currently looks like this: 

Foodie123_0-1686671327721.png

I have 4 expressions w/ definitions that I am trying to show:

- Experience Trend Selected

Definition: sum(ExperienceTrend)

 

- Future Trend Selected

Definition: sum(FutureTrend)

 

- Experience Trend Realized

Definition: sum(ExperienceTrend)

 

- Future Trend Realized

Definition: sum(FutureTrend)

 

Is it because I have the same definitions?

Thank you in advance!

 

 

Labels (1)
  • Chart

1 Solution

Accepted Solutions
Foodie123
Contributor III
Contributor III
Author

I just needed to have the fields equal to the selection in my definition.

For instance,

sum({<TrendType={'Frequency'},Selected_Realized={'Selected'}>}ExperienceTrend)

 

View solution in original post

3 Replies
Or
MVP
MVP

Presumably, since you have two sets of identical expressions, the two extra lines are there, just not visible because they are completely overlapped by another line.

If you change the first two lines to being dashed/dotted, you'll presumably be able to see the other line below.

Foodie123
Contributor III
Contributor III
Author

I tried changing the first two lines to being dotted but it is still not showing up... 

Foodie123_0-1686675423789.png

I am trying to output this data to the chart

Foodie123_1-1686675650221.png

When I don't make any selections to the Selected_Realized field, it just sums it up the ExperienceTrend and FutureTrend, which makes sense based on my definition of summing up those values.. But I am unsure what to put in my definition so that it will sum up the values based on other fields.

 

Foodie123
Contributor III
Contributor III
Author

I just needed to have the fields equal to the selection in my definition.

For instance,

sum({<TrendType={'Frequency'},Selected_Realized={'Selected'}>}ExperienceTrend)