https://community.qlik.com/t5/App-Development/Counting-across-date-dimension/m-p/1619009#M63325 <P>Better If you could explain logic behind to get numbers?</P> Sat, 31 Aug 2019 02:45:53 GMT Anil_Babu_Samineni 2019-08-31T02:45:53Z https://community.qlik.com/t5/App-Development/Counting-across-date-dimension/m-p/1618958#M63324 <P>Hello!</P><P>I'm trying to generate a table or bar graph that shows the backlog (Total Bookings - Total Shipments) based on the Ship Date.</P><P>This is how my table is structured:</P><TABLE><TBODY><TR><TD>Project</TD><TD>Date Project Created</TD><TD>Date Actual Ship</TD></TR><TR><TD>GT-00373</TD><TD>11/24/09</TD><TD>5/14/10</TD></TR><TR><TD>GT-00374</TD><TD>11/24/09</TD><TD>6/02/10</TD></TR><TR><TD>GT-00375</TD><TD>11/24/09</TD><TD>6/08/10</TD></TR><TR><TD>GT-00128</TD><TD>3/25/09</TD><TD>2/13/12</TD></TR><TR><TD>GT-00728</TD><TD>7/03/11</TD><TD>8/04/12</TD></TR><TR><TD>GT-00129</TD><TD>3/25/09</TD><TD>3/14/13</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is approximately how I want the visual to look:</P><TABLE><TBODY><TR><TD>5/14/10</TD><TD>4</TD></TR><TR><TD>6/02/10</TD><TD>3</TD></TR><TR><TD>6/08/10</TD><TD>2</TD></TR><TR><TD>2/13/12</TD><TD>2</TD></TR><TR><TD>8/04/12</TD><TD>1</TD></TR><TR><TD>3/14/13</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any suggestions?</P> Sat, 16 Nov 2024 04:48:40 GMT https://community.qlik.com/t5/App-Development/Counting-across-date-dimension/m-p/1618958#M63324 WiscoSippi 2024-11-16T04:48:40Z https://community.qlik.com/t5/App-Development/Counting-across-date-dimension/m-p/1619009#M63325 <P>Better If you could explain logic behind to get numbers?</P> Sat, 31 Aug 2019 02:45:53 GMT https://community.qlik.com/t5/App-Development/Counting-across-date-dimension/m-p/1619009#M63325 Anil_Babu_Samineni 2019-08-31T02:45:53Z