topic Building Chart using two dimensions in QlikView https://community.qlik.com/t5/QlikView/Building-Chart-using-two-dimensions/m-p/1402714#M817373 <HTML><HEAD></HEAD><BODY><P>Dear Collegues,</P><P></P><P>I would like to create a chart which will show the real performance and its forecast.</P><P></P><P>I have a table in the following format:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Realized_Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Forecast_Data</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantity</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">01/01/2017</TD><TD style="padding: 2px;">10/01/2017</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">03/01/2017</TD><TD style="padding: 2px;">01/01/2017</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">10/02/2017</TD><TD style="padding: 2px;">300</TD></TR></TBODY></TABLE><P></P><P>Then the chart would look like this:</P><P></P><P><IMG alt="Chart Real x Forecast.JPG" class="jive-image image-1" src="/legacyfs/online/174972_Chart Real x Forecast.JPG" style="height: 263px; width: 620px;" /></P><P></P><P>Is there anyway I can build this chart keeping the table´s structure?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Building Chart using two dimensions https://community.qlik.com/t5/QlikView/Building-Chart-using-two-dimensions/m-p/1402714#M817373 <HTML><HEAD></HEAD><BODY><P>Dear Collegues,</P><P></P><P>I would like to create a chart which will show the real performance and its forecast.</P><P></P><P>I have a table in the following format:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Realized_Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Forecast_Data</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantity</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">01/01/2017</TD><TD style="padding: 2px;">10/01/2017</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">03/01/2017</TD><TD style="padding: 2px;">01/01/2017</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">10/02/2017</TD><TD style="padding: 2px;">300</TD></TR></TBODY></TABLE><P></P><P>Then the chart would look like this:</P><P></P><P><IMG alt="Chart Real x Forecast.JPG" class="jive-image image-1" src="/legacyfs/online/174972_Chart Real x Forecast.JPG" style="height: 263px; width: 620px;" /></P><P></P><P>Is there anyway I can build this chart keeping the table´s structure?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Building-Chart-using-two-dimensions/m-p/1402714#M817373 Anonymous 2020-11-25T16:16:04Z Re: Building Chart using two dimensions https://community.qlik.com/t5/QlikView/Building-Chart-using-two-dimensions/m-p/1402715#M817374 <HTML><HEAD></HEAD><BODY><P>You will need to make use of </P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Tue, 29 Aug 2017 14:33:31 GMT https://community.qlik.com/t5/QlikView/Building-Chart-using-two-dimensions/m-p/1402715#M817374 sunny_talwar 2017-08-29T14:33:31Z