topic Re: How can I calculate a logarithmic trend in QlikView? in QlikView

How can I calculate a logarithmic trend in QlikView?

rluciano1012 — Mon, 02 Jul 2012 16:35:29 GMT

I would like to be able to get a logarithmic trend line in a QlikView scatter chart (or any other type of chart like a straight table) like I can get in Excel. For example, I want to get a logarithmic trend line on direct labor hours (Y axis) and sales (X axis) like this Excel chart. The second chart below it I created using QlikView and with trendline Exponential, but as you will see, the curve is quite different. QlikView does not have Logarithmic as a trendline option.

The idea is we should gain labor efficiency as sales increases, so we want a line that is more like this Excel chart. The trend line (direct labor hours) should increase as sales increases but then start to gradually level off or have a slight inclease (slope) to it. I found some formulas that could simulate it in Excel using a formula like this =LINEST( LN(Known Y Values), LN(Known X Values)) as an array in Excel or a regular Excel formula =INDEX( LINEST( LN(C58:C65), LN(B58:B65)), 1). The problem I'm having is there is not a LN function in QlikView. I'm not strong at trigonometry so there may be another way to solve this using QlikView functions. I have attached the sample data if anyone needs it. Can anyone help me?

Re: How can I calculate a logarithmic trend in QlikView?

swuehl — Mon, 02 Jul 2012 16:58:37 GMT

In QlikView, the natural logarithm (Base e) is calculated using function log()

log(x )

The natural logarithm of x. The function is only defined if x > 0. The result is a number.

So compared to Excel, QlikViews logarithmic functions are called log(), log10(), while in Excel they are called ln(), log10().

Hope this helps,

Stefan

Re: How can I calculate a logarithmic trend in QlikView?

Mon, 02 Jul 2012 17:14:53 GMT

To my knowledge qv supports only few trendline options in which log is not avaiable. I am not sure if this is included in qv 11.

Regards,

Kiran Rokkam.

Re: How can I calculate a logarithmic trend in QlikView?

rluciano1012 — Mon, 02 Jul 2012 17:57:44 GMT

Thanks, I will give that a try.

Ross

On Mon, Jul 2, 2012 at 12:58 PM, swuehl <