Hi,
I have set of 3 questions,
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.
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.
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.
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.
I am attaching the Excel report which is my target report.
and the qlikview report, which shows till where i have progressed.
