Creating a chart with multiple variables

Joanna303 — Wed, 10 Mar 2021 17:53:43 GMT

Hi,

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.

Many thanks in advance.

topic Creating a chart with multiple variables in Search the Community

Creating a chart with multiple variables