topic Re: Replicating the graph from Excel in QlikView

Replicating the graph from Excel

sijojoseph22 — Tue, 18 Aug 2015 13:35:20 GMT

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

Re: Replicating the graph from Excel

yevgeniy — Tue, 18 Aug 2015 13:56:13 GMT

Hi,

Watch it

Re: Replicating the graph from Excel

sijojoseph22 — Tue, 18 Aug 2015 13:59:11 GMT

Thanks, but this is not the replica power.

Regards,

Sijo

Re: Replicating the graph from Excel

kuczynska — Tue, 18 Aug 2015 14:11:22 GMT

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

Re: Replicating the graph from Excel

sijojoseph22 — Tue, 18 Aug 2015 14:14:57 GMT

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

Thanks

SIjo

Re: Replicating the graph from Excel

Anonymous — Tue, 18 Aug 2015 14:38:21 GMT

This?

Re: Replicating the graph from Excel

kuczynska — Tue, 18 Aug 2015 14:45:34 GMT

Trendline equations aren't the same:

and:

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

Re: Replicating the graph from Excel

Anonymous — Tue, 18 Aug 2015 14:50:27 GMT

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

Re: Replicating the graph from Excel

sijojoseph22 — Tue, 18 Aug 2015 15:02:03 GMT

Thanks for your effort.

Re: Replicating the graph from Excel

sijojoseph22 — Wed, 19 Aug 2015 13:13:02 GMT

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