topic Re: Finding the slope in QlikView

Finding the slope

Thu, 27 Mar 2014 14:35:51 GMT

attached is the picture of my dashboard. As you can see in the graph the linear formula which refer to the gradient is correct

but in the table it shows a different value

formula used in the table is =linest_m(finalMean,TQuarter)

where TQuarter is referred as dual(Quarter,AutoNumber(Quarter) as TQuarter

PLEASE HELP

Re: Finding the slope

Nicole-Smith — Thu, 27 Mar 2014 14:56:56 GMT

Have a look at this thread: How to get Equation and value R when I marked Linear in Trendlines

Re: Finding the slope

Sat, 29 Mar 2014 11:07:29 GMT

Actually Nicole i did an if statement for Quarter to be referred as numbers and that give the correct answer.

That means when i use the dual(Quarter,AutoNumber(Quarter) as TQuarter its not doing in correct way which cause a problem.

For the mean time i can make if statements which match quarter to a number, but for the sake of learning i need to understand what was wrong in my formula. Thank you for the support

Sincerely

Bilal

From the ARAB World