https://community.qlik.com/t5/QlikView/Count-incremental-user-day-by-day/m-p/1840885#M1215279 <P>Hi all!</P><P>i have a table with daily user log in, i need to count day by day the distinct user.</P><P>Example:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>day</TD><TD>user_id</TD></TR><TR><TD>01-gen</TD><TD>1</TD></TR><TR><TD>01-gen</TD><TD>2</TD></TR><TR><TD>02-gen</TD><TD>1</TD></TR><TR><TD>02-gen</TD><TD>3</TD></TR><TR><TD>03-gen</TD><TD>4</TD></TR><TR><TD>03-gen</TD><TD>3</TD></TR><TR><TD>04-gen</TD><TD>2</TD></TR><TR><TD>04-gen</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The results i need is:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>day</TD><TD>user_id</TD></TR><TR><TD>01-gen</TD><TD>2</TD></TR><TR><TD>02-gen</TD><TD>3</TD></TR><TR><TD>03-gen</TD><TD>4</TD></TR><TR><TD>04-gen</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>where at 1st i have 2 user logged in, at 2nd 3 user.... and at 4th of the month i don't have new user so stay at 4 user logged.</P><P>To complicate i have to do this for two year, whit a view of month.</P><P>&nbsp;</P><P>how can i do?</P><P>&nbsp;</P> Fri, 01 Oct 2021 12:42:37 GMT Samu_512 2021-10-01T12:42:37Z https://community.qlik.com/t5/QlikView/Count-incremental-user-day-by-day/m-p/1840885#M1215279 <P>Hi all!</P><P>i have a table with daily user log in, i need to count day by day the distinct user.</P><P>Example:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>day</TD><TD>user_id</TD></TR><TR><TD>01-gen</TD><TD>1</TD></TR><TR><TD>01-gen</TD><TD>2</TD></TR><TR><TD>02-gen</TD><TD>1</TD></TR><TR><TD>02-gen</TD><TD>3</TD></TR><TR><TD>03-gen</TD><TD>4</TD></TR><TR><TD>03-gen</TD><TD>3</TD></TR><TR><TD>04-gen</TD><TD>2</TD></TR><TR><TD>04-gen</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The results i need is:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>day</TD><TD>user_id</TD></TR><TR><TD>01-gen</TD><TD>2</TD></TR><TR><TD>02-gen</TD><TD>3</TD></TR><TR><TD>03-gen</TD><TD>4</TD></TR><TR><TD>04-gen</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>where at 1st i have 2 user logged in, at 2nd 3 user.... and at 4th of the month i don't have new user so stay at 4 user logged.</P><P>To complicate i have to do this for two year, whit a view of month.</P><P>&nbsp;</P><P>how can i do?</P><P>&nbsp;</P> Fri, 01 Oct 2021 12:42:37 GMT https://community.qlik.com/t5/QlikView/Count-incremental-user-day-by-day/m-p/1840885#M1215279 Samu_512 2021-10-01T12:42:37Z