I am new to Qlik and am struggling to create a chart displaying as It would look on excel. I will try and explain as best I can how I want it to look below. My main issue is that anytime I enter a measure, it must be followed by an aggregation and I simply want it to display Dates/months.
Y axis : Months for when things are due
X axis : All the project stages
Input data: The excel sheet has a list of projects, each project goes through 7 stages and have start/end dates against each stage. I would like the chart to know from the date what month it should be ordered into and output (when filtered to a single project) all the 7 stages on the x axis, with the y axis indicating which month each stage completes in.
Any advice on how to get all 7 stages and the dates onto one chart? I have set a filter at the top so that it can select a single project from a list.
