topic Re: Current Month Subsequent Users in respective month(with Month always starting from Jan) in App Development https://community.qlik.com/t5/App-Development/Current-Month-Subsequent-Users-in-respective-month-with-Month/m-p/2490710#M101979 <P>Can you share solution for above question&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/33037">@poojashribanger</a>&nbsp;</P> <P>&nbsp;</P> Tue, 05 Nov 2024 07:09:26 GMT Divine_rider 2024-11-05T07:09:26Z Current Month Subsequent Users in respective month(with Month always starting from Jan) https://community.qlik.com/t5/App-Development/Current-Month-Subsequent-Users-in-respective-month-with-Month/m-p/2466683#M99265 <P>Hi all,</P> <P>I Have below table where i am trying to identify monthly subsequent users.</P> <P>Logic for subsequent users is All those users present in jan ,check if they are available in Succeeding months.</P> <P>Logic for Feb is also same but the month to display should start from Jan as shown in below table.</P> <P>Source Table.</P> <TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0" data-sheets-root="1" data-sheets-baot="1"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD>Date</TD> <TD>UserID</TD> <TD>active flag</TD> </TR> <TR> <TD>1/1/2024</TD> <TD>a</TD> <TD>Y</TD> </TR> <TR> <TD>1/2/2024</TD> <TD>b</TD> <TD>Y</TD> </TR> <TR> <TD>1/3/2024</TD> <TD>c</TD> <TD>Y</TD> </TR> <TR> <TD>1/4/2024</TD> <TD>d</TD> <TD>Y</TD> </TR> <TR> <TD>1/5/2024</TD> <TD>e</TD> <TD>Y</TD> </TR> <TR> <TD>1/6/2024</TD> <TD>f</TD> <TD>Y</TD> </TR> <TR> <TD>1/7/2024</TD> <TD>g</TD> <TD>Y</TD> </TR> <TR> <TD>1/8/2024</TD> <TD>h</TD> <TD>Y</TD> </TR> <TR> <TD>1/9/2024</TD> <TD>i</TD> <TD>Y</TD> </TR> <TR> <TD>1/10/2024</TD> <TD>j</TD> <TD>N</TD> </TR> <TR> <TD>1/11/2024</TD> <TD>k</TD> <TD>Y</TD> </TR> <TR> <TD>1/12/2024</TD> <TD>l</TD> <TD>Y</TD> </TR> <TR> <TD>2/1/2024</TD> <TD>a</TD> <TD>N</TD> </TR> <TR> <TD>2/2/2024</TD> <TD>b</TD> <TD>Y</TD> </TR> <TR> <TD>2/3/2024</TD> <TD>c</TD> <TD>Y</TD> </TR> <TR> <TD>2/4/2024</TD> <TD>d</TD> <TD>Y</TD> </TR> <TR> <TD>2/5/2024</TD> <TD>e</TD> <TD>Y</TD> </TR> <TR> <TD>2/6/2024</TD> <TD>f</TD> <TD>Y</TD> </TR> <TR> <TD>2/7/2024</TD> <TD>g</TD> <TD>Y</TD> </TR> <TR> <TD>2/8/2024</TD> <TD>h</TD> <TD>Y</TD> </TR> <TR> <TD>2/9/2024</TD> <TD>i</TD> <TD>Y</TD> </TR> <TR> <TD>3/1/2024</TD> <TD>a</TD> <TD>Y</TD> </TR> <TR> <TD>3/2/2024</TD> <TD>b</TD> <TD>Y</TD> </TR> <TR> <TD>3/3/2024</TD> <TD>c</TD> <TD>Y</TD> </TR> <TR> <TD>3/4/2024</TD> <TD>d</TD> <TD>Y</TD> </TR> <TR> <TD>3/5/2024</TD> <TD>e</TD> <TD>Y</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to display Output table in pivot as well.</P> <P>Output table.</P> <TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0" data-sheets-root="1" data-sheets-baot="1"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD>OutPut</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>Month Year</TD> <TD>Month</TD> <TD>Output</TD> </TR> <TR> <TD>Jan 2024</TD> <TD>Jan</TD> <TD>11</TD> </TR> <TR> <TD>Jan 2024</TD> <TD>Feb</TD> <TD>8</TD> </TR> <TR> <TD>Jan 2024</TD> <TD>Mar</TD> <TD>5</TD> </TR> <TR> <TD>Feb 2024</TD> <TD>Jan</TD> <TD>8</TD> </TR> <TR> <TD>Feb 2024</TD> <TD>Feb</TD> <TD>4</TD> </TR> <TR> <TD>Mar 2024</TD> <TD>Jan</TD> <TD>5</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0" data-sheets-root="1" data-sheets-baot="1"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD> <DIV> <DIV>Result in Pivot Table</DIV> </DIV> </TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD colspan="3" rowspan="1">Month</TD> </TR> <TR> <TD>MonthYear</TD> <TD>Jan</TD> <TD>Feb</TD> <TD>Mar</TD> </TR> <TR> <TD>Jan 2024</TD> <TD>11</TD> <TD>8</TD> <TD>5</TD> </TR> <TR> <TD>Feb 2024</TD> <TD>8</TD> <TD>4</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>Mar 2024</TD> <TD>5</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Could someone please help me On this.</P> <P>&nbsp;</P> <P>Thanks in Advance.</P> Fri, 15 Nov 2024 20:55:57 GMT https://community.qlik.com/t5/App-Development/Current-Month-Subsequent-Users-in-respective-month-with-Month/m-p/2466683#M99265 poojashribanger 2024-11-15T20:55:57Z Re: Current Month Subsequent Users in respective month(with Month always starting from Jan) https://community.qlik.com/t5/App-Development/Current-Month-Subsequent-Users-in-respective-month-with-Month/m-p/2490698#M101977 <P>Issue Resolved</P> <P>&nbsp;</P> Tue, 05 Nov 2024 04:29:32 GMT https://community.qlik.com/t5/App-Development/Current-Month-Subsequent-Users-in-respective-month-with-Month/m-p/2490698#M101977 poojashribanger 2024-11-05T04:29:32Z Re: Current Month Subsequent Users in respective month(with Month always starting from Jan) https://community.qlik.com/t5/App-Development/Current-Month-Subsequent-Users-in-respective-month-with-Month/m-p/2490710#M101979 <P>Can you share solution for above question&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/33037">@poojashribanger</a>&nbsp;</P> <P>&nbsp;</P> Tue, 05 Nov 2024 07:09:26 GMT https://community.qlik.com/t5/App-Development/Current-Month-Subsequent-Users-in-respective-month-with-Month/m-p/2490710#M101979 Divine_rider 2024-11-05T07:09:26Z