topic Basic Graph problem.... in QlikView https://community.qlik.com/t5/QlikView/Basic-Graph-problem/m-p/379318#M571959 <HTML><HEAD></HEAD><BODY><DIV>Hi,</DIV><DIV> </DIV><DIV>I am new to Qlikview (using 9) and I have what seems to be a basic issue that drives me nuts not to manage to solve it alone...</DIV><DIV> </DIV><DIV>I receive from finance a table like this :</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales Jan 10</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales Feb 10</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales March 10</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>goes on for 10000 rows</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV> </DIV><DIV>The file is in Excel and I can't obviously do a transpose of copy each colum as with 10k products + Sales since 2009 on a Monthly basis to which must be added budget numbers + actuals +++ It would take me days.</DIV><DIV> </DIV><DIV>I guess that Developers in QlikView have thought of a very simple way to do a graph like this</DIV><DIV> </DIV><DIV>x axis : Month</DIV><DIV>Y axis : Sales</DIV><DIV> </DIV><DIV>Sales value being given as per product selection. </DIV><DIV>I manage to do it for 1 month, but I can't figure out how to put 2 or more months in the axis without creating a nightmare.</DIV><DIV>I attached a sample of the data....</DIV></BODY></HTML> Tue, 21 Aug 2012 01:23:06 GMT 2012-08-21T01:23:06Z Basic Graph problem.... https://community.qlik.com/t5/QlikView/Basic-Graph-problem/m-p/379318#M571959 <HTML><HEAD></HEAD><BODY><DIV>Hi,</DIV><DIV> </DIV><DIV>I am new to Qlikview (using 9) and I have what seems to be a basic issue that drives me nuts not to manage to solve it alone...</DIV><DIV> </DIV><DIV>I receive from finance a table like this :</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales Jan 10</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales Feb 10</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales March 10</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>goes on for 10000 rows</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV> </DIV><DIV>The file is in Excel and I can't obviously do a transpose of copy each colum as with 10k products + Sales since 2009 on a Monthly basis to which must be added budget numbers + actuals +++ It would take me days.</DIV><DIV> </DIV><DIV>I guess that Developers in QlikView have thought of a very simple way to do a graph like this</DIV><DIV> </DIV><DIV>x axis : Month</DIV><DIV>Y axis : Sales</DIV><DIV> </DIV><DIV>Sales value being given as per product selection. </DIV><DIV>I manage to do it for 1 month, but I can't figure out how to put 2 or more months in the axis without creating a nightmare.</DIV><DIV>I attached a sample of the data....</DIV></BODY></HTML> Tue, 21 Aug 2012 01:23:06 GMT https://community.qlik.com/t5/QlikView/Basic-Graph-problem/m-p/379318#M571959 2012-08-21T01:23:06Z Re: Basic Graph problem.... https://community.qlik.com/t5/QlikView/Basic-Graph-problem/m-p/379319#M571960 <HTML><HEAD></HEAD><BODY><P>You have to a crosstable load from the excel and trasform it to a straight table. Enclosed the example.</P><P></P><P>Kiran.</P></BODY></HTML> Tue, 21 Aug 2012 02:34:11 GMT https://community.qlik.com/t5/QlikView/Basic-Graph-problem/m-p/379319#M571960 2012-08-21T02:34:11Z Re: Basic Graph problem.... https://community.qlik.com/t5/QlikView/Basic-Graph-problem/m-p/379320#M571961 <HTML><HEAD></HEAD><BODY><P>Thnaks the key word I was missing is Crosstable !</P><P>With your script and the keyword I managed to find the answer in the QlikView tutorial !! Lesson 21 for those interested.</P><P></P><P>Thanks</P><P>again</P></BODY></HTML> Tue, 21 Aug 2012 10:08:18 GMT https://community.qlik.com/t5/QlikView/Basic-Graph-problem/m-p/379320#M571961 2012-08-21T10:08:18Z