topic Re: Share Change Calculation in QlikView

Share Change Calculation

Mon, 03 Jun 2013 05:42:37 GMT

Hi All,

(Sum(Product Volume)/Sum(All
Products Volume)*100) - (((Sum(Product Volume)-(sum(Product Volume
Change)/(Sum(All Products Volume - Sum(Sum(All Products Volume Change))*100)

Above is the logic to calculate share change. I am having problem in Capping Share Change.

Please guide me how to achieve capping of share change in qlikview.

Thanks,

Kumar Gauraw

Re: Share Change Calculation

er_mohit — Mon, 03 Jun 2013 05:57:10 GMT

Try this

sum((Sum(Product Volume)/Sum(total Products Volume)*100) - Sum(Product Volume)-(sum(Product Volume Change))/(Sum(total Products Volume) - Sum(total Products Volume Change))*100)

r u trying to do check on relative in expression tab while simple writ the expression sum(Product Volume)

hope it helps

Re: Share Change Calculation

Mon, 03 Jun 2013 08:56:47 GMT

Hi Mohit,

I need to Calculate share Change on the basis of Share. I am able to do the capping for share and now I need to the Capping for Share Change using Share.

Thanks,

Gauraw