Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bbi_mba_76
Valued Contributor

Re: Re: Trend line showing the combination of data?

I set the trendlines only for the difference

Not applicable

Re: Trend line showing the combination of data?

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

Re: Trend line showing the combination of data?

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)