Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trend line showing the combination of data?


Hi,

I have two Line charts.

Chart A have

Dimension: Band

Expression: Sum(Number of Cases)

Chart B Have

Dimension: Band

Expression: Sum(Cases)

I want to combine the two charts. I need to show the trend line of sum of Cases when compared to last week and current week.

Can anyone suggest me please how to set this.

Thanks.

12 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

I set the trendlines only for the difference

Not applicable
Author

Thanks. seems found the solution But I will let you know if this is not my user needs?

its_anandrjs

Create a single chart

Dimension:- Band

Expression for 15042014:- Sum({< Date = {'$(=date( WeekStart(Today())-6))'}>} [Number of Cases])

Expression for 23042014:- Sum({< Date = {'$(=Today()))'}>} Cases)

Expression Difference:- Sum({< Date = {'$(=date( WeekStart(Today())-6))'}>} [Number of Cases]) -

                                   Sum({< Date = {'$(=Today()))'}>} Cases)