topic Re: script require for monthly growth in QlikView

script require for monthly growth

yadav_anil782 — Tue, 19 May 2015 07:17:10 GMT

Dear All,

i have 2015 month wise sale , now i need help to create monthly sale growth kpi. plz help what will be script for kpi. i have attached my row data of 2015 sale .

Re: script require for monthly growth

yadav_anil782 — Tue, 19 May 2015 07:31:22 GMT

this is request to you all, plz share asap if can possible

Re: script require for monthly growth

datanibbler — Tue, 19 May 2015 07:37:57 GMT

Hi anil,

well, loading that data into QlikView should not be a problem, just use the table_wizard. What type of chart do you want to create out of it? A barchart is usually the easiest to read for that kind of data - I think so.

You can calculate the growth month_over_month in the script by using the PREVIOUS() function.

HTH

Re: script require for monthly growth

yadav_anil782 — Tue, 19 May 2015 09:02:18 GMT

Hi , i'm using bar chart that is not issue but i'm not able to wright script for calculate growth from given value with previous() function

Re: script require for monthly growth

ganeshreddy — Tue, 19 May 2015 09:08:39 GMT

Hi Anil,

I presume that the above() will do for this situation. if you need any further info please send me a sample QVW.

Cheers,

Ganesh.

Re: script require for monthly growth

yadav_anil782 — Tue, 19 May 2015 09:35:27 GMT

Dear Ganesh,

i have attached excel sheet and data is given inside monthly wise , i'm trying previous function but it is not correct

Re: script require for monthly growth

ganeshreddy — Tue, 19 May 2015 09:54:05 GMT

Hi Anil,

PFA it may help you.

Cheers,

Ganesh

Re: script require for monthly growth

ganeshreddy — Tue, 19 May 2015 10:06:54 GMT

I think your problem is with sorting dimension(Month) like jan,feb,mar,apr...etc.. Use pick() and match() in calculated dimension to achieve the sorting order. And before check the QVW i have attached.

Cheers,

Ganesh

Re: script require for monthly growth

jagan — Tue, 19 May 2015 10:07:09 GMT

HI,

Try like this

Script:

Data:

LOAD Year,

Month,

[Sales(Lacs)],

Previous([Sales(Lacs)]) AS PreviousMonthSales

FROM

[2015 SALE.xlsx]

(ooxml, embedded labels, table is b7481fec08dd4c0a9f43dad15417755);

Chart : Straight Table

Dimension : Year, Month

Expression:=(Sum([Sales(Lacs)]) - Sum(PreviousMonthSales))/Sum([Sales(Lacs)])

Hope this helps you.

Regards,

Jagan.