topic Serveral dates in one table chart in QlikView https://community.qlik.com/t5/QlikView/Serveral-dates-in-one-table-chart/m-p/208759#M64017 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a table that shows me orders sorted by order month.<BR /><BR />orderdate | orderamount<BR />==========================<BR />03/09 | 1000<BR />04/09 | 2000<BR />05/09 | 1000<BR /><BR />I have a second table with customers. Customers have a datefield that shows me when they<BR />became customers. I'm doing a count on this to get the new customers by year.</P><P>customer_id | customerdate<BR />==========================<BR /> 1 | 03/09<BR />2 | 04/09<BR />3 | 05/09</P><P>It's possible that customer became customers in e.g. april and their first order was in may.<BR />I would like to show both information (orderamount and count) in one table. I know that there's the option to concatenate these tables or creating a calender and use this field. Let's say this isn't an option <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>Is it possible to add the count to the first table (I know this isn't correct). Is there a way to get the count "independent" from the dimension (and do something like "count( if customer_date = orderdate)" ?</P><P>Thanks for your help.</P><P>Regards</P><P>Elzo</P><P></P></BODY></HTML> Wed, 07 Oct 2009 17:53:08 GMT 2009-10-07T17:53:08Z Serveral dates in one table chart https://community.qlik.com/t5/QlikView/Serveral-dates-in-one-table-chart/m-p/208759#M64017 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a table that shows me orders sorted by order month.<BR /><BR />orderdate | orderamount<BR />==========================<BR />03/09 | 1000<BR />04/09 | 2000<BR />05/09 | 1000<BR /><BR />I have a second table with customers. Customers have a datefield that shows me when they<BR />became customers. I'm doing a count on this to get the new customers by year.</P><P>customer_id | customerdate<BR />==========================<BR /> 1 | 03/09<BR />2 | 04/09<BR />3 | 05/09</P><P>It's possible that customer became customers in e.g. april and their first order was in may.<BR />I would like to show both information (orderamount and count) in one table. I know that there's the option to concatenate these tables or creating a calender and use this field. Let's say this isn't an option <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>Is it possible to add the count to the first table (I know this isn't correct). Is there a way to get the count "independent" from the dimension (and do something like "count( if customer_date = orderdate)" ?</P><P>Thanks for your help.</P><P>Regards</P><P>Elzo</P><P></P></BODY></HTML> Wed, 07 Oct 2009 17:53:08 GMT https://community.qlik.com/t5/QlikView/Serveral-dates-in-one-table-chart/m-p/208759#M64017 2009-10-07T17:53:08Z