Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Month wise New Dealer Volume

Hi Dear Frinds,

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

Capture.PNG

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

0 Replies