topic Re: 3 Month Volume Loss in QlikView

3 Month Volume Loss

anikkumarhole — Wed, 25 Nov 2020 16:16:04 GMT

Hi Dear Friends i Need Help on Below scenario ,

1) For 3 Months Volume Loss

where in we have Dimension: Month and Measure: Sum(Qty) per Dealer we want to see month on month Volume loss per Dealer.

Suppose in

In May=if(May Qty>0 and (Jun+Jul+ Aug) Qty=0 the Sum(Qty)
In Jun=if(Jun Qty>0 and (Jul+Aug+ Sep) Qty=0 the Sum(Qty) and so on

Anil_Babu_Samineni — Fri, 17 Mar 2017 16:22:56 GMT

In May=if(May Qty>0 and (Jun+Jul+ Aug) Qty=0 the Sum(Qty)

In Jun=if(Jun Qty>0 and (Jul+Aug+ Sep) Qty=0 the Sum(Qty) and so on

Try this?

If(Sum({<Month = {'Vol_May'}>}Qty)>0 and Sum({<Month = {'Vol_Jun','Vol_Jul','Vol_Aug'}>}Qty)=0, Sum(Qty)) as MayQuantity,

If(Sum({<Month = {'Vol_Jun'}>}Qty)>0 and Sum({<Month = {'Vol_Jul','Vol_Aug','Vol_Sep'}>}Qty)=0, Sum(Qty))

as JunQunatity,

.......

anikkumarhole — Fri, 17 Mar 2017 17:12:00 GMT

I want to show in charts it's should be dynamic. Monthyear on monthyear

Thanks & Regards,

Anik Hole