topic Line Chart in QlikView https://community.qlik.com/t5/QlikView/Line-Chart/m-p/170208#M40712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have set of 3 questions,</P><P>1. I had to bring the CY ( current year) and PY (previuos year) Values for the measures for the past 4 weeks. For this i created 2 tables and created a dummy table in the PY, whcih would contains sysdate - 1 record.</P><P>Through this key,I link both the tables in Qlikview and display the CY and PY measure values besides each other. Is there any other approach to do this.</P><P>2. The Line chart needs to disply the week start date of the CY and PY below. I have the values in the qlikview table, But i am able to display only the Week start date of the CY. How can also get the PY week start dates displayed.</P><P>3. I have 2 Y axis, and I have to display the measure names vertically along the X- Axis line. how can this be done in qlikview.</P><P>I am attaching the Excel report which is my target report.</P><P>and the qlikview report, which shows till where i have progressed.</P><P></P></BODY></HTML> Sat, 21 Aug 2010 10:25:19 GMT qlik_venu 2010-08-21T10:25:19Z Line Chart https://community.qlik.com/t5/QlikView/Line-Chart/m-p/170208#M40712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have set of 3 questions,</P><P>1. I had to bring the CY ( current year) and PY (previuos year) Values for the measures for the past 4 weeks. For this i created 2 tables and created a dummy table in the PY, whcih would contains sysdate - 1 record.</P><P>Through this key,I link both the tables in Qlikview and display the CY and PY measure values besides each other. Is there any other approach to do this.</P><P>2. The Line chart needs to disply the week start date of the CY and PY below. I have the values in the qlikview table, But i am able to display only the Week start date of the CY. How can also get the PY week start dates displayed.</P><P>3. I have 2 Y axis, and I have to display the measure names vertically along the X- Axis line. how can this be done in qlikview.</P><P>I am attaching the Excel report which is my target report.</P><P>and the qlikview report, which shows till where i have progressed.</P><P></P></BODY></HTML> Sat, 21 Aug 2010 10:25:19 GMT https://community.qlik.com/t5/QlikView/Line-Chart/m-p/170208#M40712 qlik_venu 2010-08-21T10:25:19Z Line Chart https://community.qlik.com/t5/QlikView/Line-Chart/m-p/170209#M40713 <HTML><HEAD></HEAD><BODY><P>This is the Target report which i want to recreate in qlikview.</P></BODY></HTML> Sat, 21 Aug 2010 10:30:08 GMT https://community.qlik.com/t5/QlikView/Line-Chart/m-p/170209#M40713 qlik_venu 2010-08-21T10:30:08Z