get the count of unique for a month also if it is repeating again in next month or occured before in previous month it should not consider

[#1]

Hi Team ,

I have a requirement that I should get the unique count of login names for a particular month and if it is repeating again in next I should not take it consideration for  unique count for the next month .

For your reference I am attaching the qvw file and output I am getting .

Please find the below desired output

Month	Unique   Distinct Count(Checking with previous months)	Unique Count
Jan 2015	3	3
Feb 2015	3	4
Mar 2015	1	5

Thanks in Advance

Sreehari

[#2]

Hi Anbu Cheliyan,

Thanks for explanation .. I think the solution you provided will be working for me

Thanks

Sreehari

[#3]

Hi Anbu Cheliyan ,

The solution you provided me is not working correctly becuase the Month field(Mar2014) I am creating from two Fields i.e Year and Month.Year is in the format like  FY2014 and Month is in format FY14 Mar.

When I use Date#(field,'MMMYYY') the month FY14 May is mapped to Mar2014 .

So I modified Date#(Field,'MMM YYYY') which is mapping FY14 May to May2014 but logic we discussed above is not working properly if I use Count =1 becuase orderby has not worked properly Can you help ?

The issue is raised in another thread,https://community.qlik.com/message/764075?et=watches.email.thread#764075

Thanks and Regards,

Sreehari