Month wise New Dealer Volume

anikkumarhole — Thu, 23 Mar 2017 05:17:20 GMT

Hi Dear Frinds,

I have created below chart which give me month wise unique new Dealer count

and Expression is:

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month = {'>=8'},[A/N]={'New'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month)

and

Min({<InvFiscal_Month = {'>=8'},[A/N]={'New'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) >= 8,

If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) - 6 > Alt(Above(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month)), 0), 1, 0)), [DMS Outlet Code], Sort))

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month = {'<8'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) ,

Count(DISTINCT {<[A/N]={'NEW'}>}[DMS Outlet Code])), InvFiscal_Month, [DMS Outlet Code]))

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month = {'>=8'},JEETPhase={'JEET Pilot'},[A/N]={'Active'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) and

Min({<InvFiscal_Month = {'>=8'},JEETPhase={'JEET Pilot'},[A/N]={'Active'},Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) >= 8, If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) - 6 > Alt(Above(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month)), 0), 1, 0)), [DMS Outlet Code], Sort))

Sum(Aggr(If(Only({<InvFiscal_Month,Month=,Quarter=>}InvFiscal_Month) = Min({<InvFiscal_Month,Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) and

Min({<InvFiscal_Month,Month=,Quarter=>}TOTAL <[DMS Outlet Code]> InvFiscal_Month) > 11,

Count(DISTINCT {<JEETPhase={'JEET 1.1'},[A/N]={'Active'},Month=,Quarter=>}[DMS Outlet Code])), InvFiscal_Month, [DMS Outlet Code]))

Using this Expression i want to show Month wise New Dealer volume agents this count. in another chart.

Thanks & Regards,

Anik

topic Month wise New Dealer Volume in QlikView

Month wise New Dealer Volume