topic Re: problem to caculate aggrgeate value in QlikView

problem to caculate aggrgeate value

davoud-jelodar — Wed, 24 Jan 2018 11:19:06 GMT

I have a problem to caculate aggrgeate value.

I have an inline data set that includes: date, price.

LOAD * Inline [

Date ,Price

13961030,0.672

13961101,0.682984

13961101,0.677617

13961101,0.661068

13961102,0.597959

13961102,0.617007

13961102,0.602065

13961101,0.083422

13961101,0.083526

13961101,0.080666

13961102,0.071412

13961102,0.072685

13961102,0.070975

];

I have a line graph with dim=Date and expertion is avg(price), that trendline slope is -0.1666 but if I use this expression "LINEST_M(aggr(avg(Price), Date),Date)" that show me -0.00439.

If I remove first line of inline data, everything will be OK.(remove date=13961030 and price=0.672). I do not know why? and I do not know how to fix it?

Re: problem to caculate aggrgeate value

sunny_talwar — Wed, 24 Jan 2018 20:33:00 GMT

When you are looking at this in your line chart, have you selected Continuous Axis?

Re: problem to caculate aggrgeate value

sunny_talwar — Wed, 24 Jan 2018 20:48:39 GMT

Check this

Re: problem to caculate aggrgeate value

davoud-jelodar — Thu, 25 Jan 2018 05:55:24 GMT

Thanks for your attention.

selected Continuous Axis is not useful for my project. But your answer help me to understand what is my problem and now I solved it. I use an ID number for distinct Date, and I use "= LINEST_M(Aggr(avg(Price),ID),ID)" instead of "LINEST_M(aggr(avg(Price), Date),Date)".and now everything is OK.

Re: problem to caculate aggrgeate value

sunny_talwar — Thu, 25 Jan 2018 16:23:14 GMT

Super

Thanks for sharing this. Please close the thread by marking correct and helpful responses.

Best,

Sunny