topic Re: How to Shift Trend Line on X-Axis? in QlikView

How to Shift Trend Line on X-Axis?

Wed, 07 Sep 2016 17:32:30 GMT

Hello,

Is it possible to shift the "Linear Avg" trendline over by 2 data points on the x-axis? Example below where it should start on 16-Jun vs at the beginning?

Beginning the chart at 16-Jun is not an option because the requirement is to begin on Apr.

Thanks in advance!

-Jason

Re: How to Shift Trend Line on X-Axis?

sunny_talwar — Wed, 07 Sep 2016 17:35:15 GMT

May be try using Above() function

Above(YourExpression, 2)

Re: How to Shift Trend Line on X-Axis?

Wed, 07 Sep 2016 17:56:59 GMT

Doesn't seem to be working with my expression:

sum(TOTAL{1<[Created Year]={'2016'}>} Price)

count(TOTAL{1<[Created Year]={'2016'}>} DISTINCT [Created CY-M])

The above gives me a total average which i use to produce the Linear Avg line. Adding in above doesn't shift the line.

Re: How to Shift Trend Line on X-Axis?

sunny_talwar — Wed, 07 Sep 2016 17:58:50 GMT

So this doesn't work for you?

Above(

Sum(TOTAL{1<[Created Year]={'2016'}>} Price)

Count(TOTAL{1<[Created Year]={'2016'}>} DISTINCT [Created CY-M]), 2)

If that is not working, would you be able to provide a sample to look at?

Re: How to Shift Trend Line on X-Axis?

Wed, 07 Sep 2016 18:05:33 GMT

No - no change to the trendline after adding in Above

Unfortunately - I can't provide any sample.

Re: How to Shift Trend Line on X-Axis?

sunny_talwar — Wed, 07 Sep 2016 18:08:15 GMT

Oh, I see, its the trendline that you are trying to change and not the actual expression. I guess you will have to recreate the trendline using an expression to get this to work

Re: How to Shift Trend Line on X-Axis?

Wed, 07 Sep 2016 18:13:02 GMT

I had thought of that but with the particular chart style, I can't just add a line. It creates an additional stacked layer on top. Hence, why I tried using a trendline.

Re: How to Shift Trend Line on X-Axis?

sunny_talwar — Wed, 07 Sep 2016 18:14:22 GMT

May be someone else can offer an advice, I am out of ideas .

Re: How to Shift Trend Line on X-Axis?

Wed, 07 Sep 2016 18:20:18 GMT

Thanks Sunny - appreciate the effort!