Share Change Calculation

[#1]

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

[er_mohit]

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

[#3]

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