topic Re: 3 calendars in 1 graph in QlikView https://community.qlik.com/t5/QlikView/3-calendars-in-1-graph/m-p/615818#M479372 <HTML><HEAD></HEAD><BODY><P>Tks!</P></BODY></HTML> Thu, 06 Feb 2014 15:09:28 GMT canmarroig 2014-02-06T15:09:28Z 3 calendars in 1 graph https://community.qlik.com/t5/QlikView/3-calendars-in-1-graph/m-p/615816#M479370 <HTML><HEAD></HEAD><BODY><P>I've a report with 3 calendars:</P><P>Order_date</P><P>Delivery_date</P><P>Invoice_date</P><P></P><P>and I've to create a bar graph where a sum for each date:</P><P>- for how many goods I've received orders, </P><P>- how many goods i've delivered, </P><P>- for how many good i've billed. </P><P></P><P>I've tried to build set analysis using in x axis Order_date and with this syntax: </P><P>sum(Order_date={'$(Delivery_date)'}&gt;}product_code)</P><P>sum(Order_date={'$(Invoice_date)'}&gt;}product_code)</P><P>And it doesn't work. How can I solve my problem? Tks</P></BODY></HTML> Thu, 06 Feb 2014 13:17:50 GMT https://community.qlik.com/t5/QlikView/3-calendars-in-1-graph/m-p/615816#M479370 canmarroig 2014-02-06T13:17:50Z Re: 3 calendars in 1 graph https://community.qlik.com/t5/QlikView/3-calendars-in-1-graph/m-p/615817#M479371 <HTML><HEAD></HEAD><BODY><P>What you need is a shared calendar. See this discussion: <A href="https://community.qlik.com/thread/66717">Tutorial - Using Common Date Dimensions and Shared Calendars</A>.</P></BODY></HTML> Thu, 06 Feb 2014 14:04:17 GMT https://community.qlik.com/t5/QlikView/3-calendars-in-1-graph/m-p/615817#M479371 Gysbert_Wassenaar 2014-02-06T14:04:17Z Re: 3 calendars in 1 graph https://community.qlik.com/t5/QlikView/3-calendars-in-1-graph/m-p/615818#M479372 <HTML><HEAD></HEAD><BODY><P>Tks!</P></BODY></HTML> Thu, 06 Feb 2014 15:09:28 GMT https://community.qlik.com/t5/QlikView/3-calendars-in-1-graph/m-p/615818#M479372 canmarroig 2014-02-06T15:09:28Z