topic Re: Stacked Line Chart in QlikView

Stacked Line Chart

Anonymous — Wed, 30 Sep 2015 07:52:58 GMT

Hi..Can anybody please help how to plot a stacked area chart by converting the existing line graphs.

I need to plot a demand and supply stacked area chart..Currently i have 3 line charts as attached. I need to have these as stacked area charts. Can anybody please share the steps how to do this in QV?

Thanks

Sanjyot

Re: Stacked Line Chart

bwisealiahmad — Wed, 30 Sep 2015 08:39:08 GMT

Hi Sanjoy,

Have look under "Style" and pick the number two from the left bottom. Originally this stacks them on top of each other, but if you take Expr1-Expr2 then with that logic it should help.

See attached.

Re: Stacked Line Chart

tresB — Wed, 30 Sep 2015 08:46:40 GMT

Goto the Style tab of the chart -> Choose one style from the Look option(last two).

Re: Stacked Line Chart

avinashelite — Wed, 30 Sep 2015 10:16:04 GMT

In the expression tab of chart properties you can use the >Display Option> next to Line > you can chose the smooth and value on the data points . This will get a chart according to your requirement

Re: Stacked Line Chart

Anonymous — Wed, 30 Sep 2015 11:09:54 GMT

!Thanks..I am getting 2 X axis when I change the style but I need only one X axis to show that the demand and supply start from the same x axis.

Re: Stacked Line Chart

tresB — Wed, 30 Sep 2015 11:18:19 GMT

Not clear. Could you share a sample qvw?

Re: Stacked Line Chart

mohammadkhatimi — Wed, 30 Sep 2015 11:19:20 GMT

Can you share a sample qvw?

Re: Stacked Line Chart

Anonymous — Thu, 01 Oct 2015 11:25:53 GMT

I have 2 expression as below

1) Supply - ceil(sum({<[Project Name]=,[Project Delivery Status]=>}Supply_HCM))

2) Active Demand - ceil(sum(if(PlanType='Demand' and ([Project Delivery Status] = 'Initiated' or [Project Delivery Status] = 'In Progress') ,Demand_HCM)))

3) Pipeline Demand - ceil(sum(if([Project Delivery Status]='On Hold' or [Project Delivery Status] = 'Not Started',Demand_HCM)))

Please elaborate what needs to done in the expression tab with the above given expressions.. I have selected the 2nd option under Style from the left bottom.

Re: Stacked Line Chart

Anonymous — Mon, 05 Oct 2015 07:25:22 GMT

Added qv file and the base files

Re: Stacked Line Chart

bwisealiahmad — Mon, 05 Oct 2015 07:43:37 GMT

See attached file for what I meant. Does that make sense? I am not sure if I fully understand, but look at it. You can also play around with the transparancy of the colors.

Bets,

AA !

Re: Stacked Line Chart

Anonymous — Mon, 05 Oct 2015 11:32:03 GMT

for some reason i am unable to download your qv file..is there any way that you can share the screenshot of your expression tabs wherever you may think i need to make changes