topic Re: Mountain chart with line in QlikView

Mountain chart with line

Tue, 02 Jun 2015 23:32:53 GMT

Hi,

I am searching for the correct visualization for my requirement. I have data where each skills having headcount(allocations) per month. Also i have capacity for those skills per month. Now I have to display this in graphical format.

The requirement is to identify which skills are over allocated or under allocated so that the allocations can be adjusted.

I would need a mountain chart of monthly headcount per skill overlapped with total capacity per month.

Since I cannot have stacked mountain chart and line chart together I am limited with showing this in tabular format with some background coloring.

Please note that I cannot make different expressions by skills because skills are dynamic per projects. Project is one more dimension which i have taken into consideration in dummy data.

I am open to change the chart type like bar chart, line chart etc as long as the requirement is fulfilled.

Sample application is attached.

Thanks in advance,

Anosh

Re: Mountain chart with line

Gysbert_Wassenaar — Wed, 03 Jun 2015 11:07:32 GMT

The only way to create that is to put two charts on top of each other. See attached qvw.

Re: Mountain chart with line

Wed, 03 Jun 2015 16:36:44 GMT

Hi Gysbert,

Thanks for your reply, but as per data it is not possible to match the x and y axis of both graph. Also if there are scrollbar on x axis then both charts will not scroll together.

Is it possible to split the axis and create both graph in one chart object? Or Any other way to fulfill the requirement.

Thanks in advance,

Anosh Nathaniel

Re: Mountain chart with line

Gysbert_Wassenaar — Wed, 03 Jun 2015 17:45:23 GMT

No, one chart uses two dimensions, the other one only one dimension. There's no way to combine that in one chart.

Re: Mountain chart with line

Wed, 03 Jun 2015 18:43:40 GMT

It's ok if 2nd chart also uses 2 dimensions. Can we then split the axis.

On Jun 3, 2015 10:46 AM, "Gysbert Wassenaar" <qcwebmaster@qlikview.com>

Re: Mountain chart with line

zeynepseda — Mon, 20 May 2019 14:16:59 GMT

Hi Anosh,

We are suffering for the same problem.. Could you find any solutions for that?

We need to make a workload graph as you have indicated, but couldn't find a way.