topic Display always total records without reading X-Axis in bar in App Development https://community.qlik.com/t5/App-Development/Display-always-total-records-without-reading-X-Axis-in-bar/m-p/1649586#M63541 <P>Hi,</P><P>These is a sample of my dataset (two tables):</P><P>Table1 (Records of users and when they were created):</P><TABLE border="1"><TBODY><TR><TD>User ID</TD><TD>DateCreated</TD><TD>UserData</TD></TR><TR><TD>1</TD><TD>20/01/2019</TD><TD>...</TD></TR><TR><TD>2</TD><TD>20/01/2019</TD><TD>...</TD></TR><TR><TD>3</TD><TD>20/02/2019</TD><TD>...</TD></TR><TR><TD>4</TD><TD>04/03/2019</TD><TD>...</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Table2 (Records of users and when they are buying):</P><TABLE border="1"><TBODY><TR><TD>User ID</TD><TD>PurchaseDate</TD><TD>Amount</TD></TR><TR><TD>1</TD><TD>25/01/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>25/02/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>27/02/2019</TD><TD>...</TD></TR><TR><TD>2</TD><TD>25/02/2019</TD><TD>...</TD></TR><TR><TD>3</TD><TD>25/02/2019</TD><TD>...</TD></TR><TR><TD>3</TD><TD>28/02/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>01/03/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>08/03/2019</TD><TD>...</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to display how many distinct users are buying per month and compare it with the total numbers of user existing.<BR /><BR />Following the previous example, it should look something like that<BR /><BR />- Blue = Users Puchasing<BR />- Green = Total Users<BR />- Axis = Month(PurchaseDate)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Captura de pantalla 2019-11-21 a las 13.22.43.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/24147iE91F94BD220F3560/image-size/medium?v=v2&amp;px=400" role="button" title="Captura de pantalla 2019-11-21 a las 13.22.43.png" alt="Captura de pantalla 2019-11-21 a las 13.22.43.png" /></span></P><P>The problem that I am having is that any formula that I try to count the UserIDs is filtered due to the relationship UserID-UserID from both tables. So whenever I try a count, since for example the UserID 4 it's not in the table at all, it doesn't count it.&nbsp;<BR /><BR />Any idea how to solve that?</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:37:26 GMT mario2 2024-11-16T19:37:26Z Display always total records without reading X-Axis in bar https://community.qlik.com/t5/App-Development/Display-always-total-records-without-reading-X-Axis-in-bar/m-p/1649586#M63541 <P>Hi,</P><P>These is a sample of my dataset (two tables):</P><P>Table1 (Records of users and when they were created):</P><TABLE border="1"><TBODY><TR><TD>User ID</TD><TD>DateCreated</TD><TD>UserData</TD></TR><TR><TD>1</TD><TD>20/01/2019</TD><TD>...</TD></TR><TR><TD>2</TD><TD>20/01/2019</TD><TD>...</TD></TR><TR><TD>3</TD><TD>20/02/2019</TD><TD>...</TD></TR><TR><TD>4</TD><TD>04/03/2019</TD><TD>...</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Table2 (Records of users and when they are buying):</P><TABLE border="1"><TBODY><TR><TD>User ID</TD><TD>PurchaseDate</TD><TD>Amount</TD></TR><TR><TD>1</TD><TD>25/01/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>25/02/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>27/02/2019</TD><TD>...</TD></TR><TR><TD>2</TD><TD>25/02/2019</TD><TD>...</TD></TR><TR><TD>3</TD><TD>25/02/2019</TD><TD>...</TD></TR><TR><TD>3</TD><TD>28/02/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>01/03/2019</TD><TD>...</TD></TR><TR><TD>1</TD><TD>08/03/2019</TD><TD>...</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to display how many distinct users are buying per month and compare it with the total numbers of user existing.<BR /><BR />Following the previous example, it should look something like that<BR /><BR />- Blue = Users Puchasing<BR />- Green = Total Users<BR />- Axis = Month(PurchaseDate)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Captura de pantalla 2019-11-21 a las 13.22.43.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/24147iE91F94BD220F3560/image-size/medium?v=v2&amp;px=400" role="button" title="Captura de pantalla 2019-11-21 a las 13.22.43.png" alt="Captura de pantalla 2019-11-21 a las 13.22.43.png" /></span></P><P>The problem that I am having is that any formula that I try to count the UserIDs is filtered due to the relationship UserID-UserID from both tables. So whenever I try a count, since for example the UserID 4 it's not in the table at all, it doesn't count it.&nbsp;<BR /><BR />Any idea how to solve that?</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:37:26 GMT https://community.qlik.com/t5/App-Development/Display-always-total-records-without-reading-X-Axis-in-bar/m-p/1649586#M63541 mario2 2024-11-16T19:37:26Z