script require for monthly growth

[yadav_anil782]

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 .

[yadav_anil782]

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

[datanibbler]

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

[yadav_anil782]

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

[ganeshreddy]

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.

[yadav_anil782]

Dear Ganesh,

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

[ganeshreddy]

Hi Anil,

PFA it may help you.

Cheers,

Ganesh

[ganeshreddy]

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

[jagan]

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.