Replicating the graph from Excel

[sijojoseph22]

Hi All,

I am having a graph in excel and need to replicate the same in QlikView. Attached the excel and QVW by loading the data.

I have created the graph using scatter chart but unable to create the line 'Power'

Please could you advise.

Thanks,

Sijo

[yevgeniy]

Hi,

Watch it

[sijojoseph22]

Thanks, but this is not the replica power.

Regards,

Sijo

[kuczynska]

In order to calculate Power line - is that a exponential/logarithmic function you are using in Excel?

[sijojoseph22]

Hi

I have selected trendline option from excel. Screen shot attached.

Thanks

SIjo

[Anonymous]

This?

[kuczynska]

Trendline equations aren't the same:

and:

But it's still better than anything else I came up

[Anonymous]

I forgot to sort by Premium in tab Sort > Expression

Anyway.....

Every value in x axis has the same space among the others... It's not correct, sorry

[sijojoseph22]

Thanks for your effort.

[sijojoseph22]

Hi All,

We are able to identify the y-interceptor and slope in qlikview.  Is there any way we can plot a line using this ?

Slope =  -0.42388452896674300000000000

Y     =  13.16213662338030000000000000

QlikView Formula

Slope: =(linest_m(Y-Axis,X-Axis))

y intercept: =exp(LINEST_b(Y-Axis ,X-Axis))

Image from Excel

Thanks,

Sijo