topic Re: Need Help to calculate SoW in QlikView

Need Help to calculate SoW

pavanthota — Mon, 06 Jun 2016 15:49:05 GMT

Hi All,

I need one help to write the expression for SOW.I am providing you the sample data in excel.

I have to calculate Sow of current year like Average of prior year and priprior year shipment divided by current year tam

I have given calculation in excel for 2016 Sow. Please check and provide me the suitable answer asap.

Thanks,

Pavan

alexdataiq — Mon, 06 Jun 2016 17:43:32 GMT

Could you provide a Sample Application?

Are you trying to do this on the script or in the UI? If it's in a pivot, you could try with Set Analysis:

RangeAvg(Sum({<Year={2015}>} Netshipmet), Sum({<Year={2014}>} Netshipmet)) / Sum({<Year={2016}>} Netshipmet)

Or instead of fixed Years, you could use some variable to calculate the Prior Years.

Regards.

pavanthota — Tue, 07 Jun 2016 05:03:57 GMT

Hi Alejando,

Thanks for your quick reply,

I need to use this expression on UI on pivot.

Same expression can i use in pivot also right.

I am attaching sample example (NetShipment= Sum(Direct and InDirect)

Could you please tell me how to write this expression in script level.

I have created the variables for prior year please check and let me know

Thanks for your suggestion to create the variables.

Thanks,

Pavan

pavanthota — Thu, 09 Jun 2016 05:41:35 GMT

Hi Alejandro,

Could you please reply to my question