topic expressions as timeline in QlikView https://community.qlik.com/t5/QlikView/expressions-as-timeline/m-p/284518#M105753 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Unfortunately the data im using is derived from a excel pivot like data, example:</P><P></P><P>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year 1 total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year 2 total&nbsp;&nbsp;&nbsp;&nbsp; Year 3 total</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>B</P><P>B</P><P></P><P>I would need to make a timeline chart out of the above, so that the Years would be on the x-axis. Can anyone help..Automatically the years are presented in the y-axis.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 23 Sep 2011 07:25:16 GMT 2011-09-23T07:25:16Z expressions as timeline https://community.qlik.com/t5/QlikView/expressions-as-timeline/m-p/284518#M105753 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Unfortunately the data im using is derived from a excel pivot like data, example:</P><P></P><P>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year 1 total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year 2 total&nbsp;&nbsp;&nbsp;&nbsp; Year 3 total</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>B</P><P>B</P><P></P><P>I would need to make a timeline chart out of the above, so that the Years would be on the x-axis. Can anyone help..Automatically the years are presented in the y-axis.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 23 Sep 2011 07:25:16 GMT https://community.qlik.com/t5/QlikView/expressions-as-timeline/m-p/284518#M105753 2011-09-23T07:25:16Z expressions as timeline https://community.qlik.com/t5/QlikView/expressions-as-timeline/m-p/284519#M105754 <HTML><HEAD></HEAD><BODY><P>tab1:</P><P></P><P> cross table(columns,value,1)</P><P></P><P>load </P><P>Product&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Year 1 total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp; Year 2 total&nbsp;&nbsp;&nbsp; , Year 3 total</P><P>from path.</P><P></P><P>Load *,</P><P>left(columns,4) as Year</P><P>resident tab1;</P><P>drop table path1;</P></BODY></HTML> Fri, 23 Sep 2011 07:30:09 GMT https://community.qlik.com/t5/QlikView/expressions-as-timeline/m-p/284519#M105754 SunilChauhan 2011-09-23T07:30:09Z