topic Re: How to get cumulative unique count ? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830813#M471181 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Tue, 31 Mar 2015 15:45:03 GMT MK_QSL 2015-03-31T15:45:03Z How to get cumulative unique count ? https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830810#M471178 <HTML><HEAD></HEAD><BODY><P>Hi Team ,</P><P></P><P>I have 4 years of data and want to show only last 2 years of data,by calculating cumulative unique count of users.</P><P>For a month I want to get unique count of name from beginning upto the month(include the month)</P><P></P><P>For your reference please find the sample input and required output</P><P></P><P>Input</P><P>=========</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82524_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Output</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/82526_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 31 Mar 2015 15:19:32 GMT https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830810#M471178 2015-03-31T15:19:32Z Re: How to get cumulative unique count ? https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830811#M471179 <HTML><HEAD></HEAD><BODY><P>Request you to provide sample data either as Inline table in Application or In Excel file which would be much easier to work and give answer...Thanks</P></BODY></HTML> Tue, 31 Mar 2015 15:28:02 GMT https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830811#M471179 MK_QSL 2015-03-31T15:28:02Z Re: How to get cumulative unique count ? https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830812#M471180 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply..</P><P>Please find the attached qvw file.</P><P></P><P>The output required is Cumulative Unique Counts and Unique Count(which is direct)</P><P></P><P>Thanks in Advance</P><P>Sreehari</P></BODY></HTML> Tue, 31 Mar 2015 15:35:11 GMT https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830812#M471180 2015-03-31T15:35:11Z Re: How to get cumulative unique count ? https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830813#M471181 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Tue, 31 Mar 2015 15:45:03 GMT https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830813#M471181 MK_QSL 2015-03-31T15:45:03Z Re: How to get cumulative unique count ? https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830814#M471182 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>Thanks for your reply.</P><P>But for me I don't have any column with Total Value or cumulative .Just have 3 Columns Year,Month, Login.</P><P></P><P>I want to Calculate unique cumulative login Count i.e from beginning to current month (includes Current month).how much is unique Login Count and also count of unique logins for current month.</P><P></P><P></P><P>Thanks in Advance</P><P>Sreehari Satheesan</P></BODY></HTML> Wed, 01 Apr 2015 09:13:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830814#M471182 2015-04-01T09:13:48Z Re: How to get cumulative  unique count ? https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830815#M471183 <HTML><HEAD></HEAD><BODY><P>Check my document and script..please</P></BODY></HTML> Wed, 01 Apr 2015 09:15:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-cumulative-unique-count/m-p/830815#M471183 MK_QSL 2015-04-01T09:15:30Z