topic Re: Stacked chart representation in QlikView

Stacked chart representation

Tue, 11 Feb 2014 05:28:25 GMT

Hi,

I need to display a stacked chart.Below mentioned is the data.

Quarter	Region	Revenue-Type	Actual/Flash	Budget
Q1	AMS	A	123	140
Q1	AMS	B	345	350
Q1	AMS	C(A+B)	468	490
Q1	AMS	D	123	160

The chart should show only C as sum of (A+B) in the stacked order and D .

Re: Stacked chart representation

sujeetsingh — Tue, 11 Feb 2014 05:44:49 GMT

See this sample

Re: Stacked chart representation

Tue, 11 Feb 2014 06:39:02 GMT

Hi Sujeet,

Thanks for your reply. Its helpful. But i need revenue type D to be shown in the same chart with out stacked representation.

And moreover the stacked representation is shown only for Actual/Flash i need it to be shown to budget in the same way..

Re: Stacked chart representation

sujeetsingh — Tue, 11 Feb 2014 12:19:52 GMT

You can try to implement it by using the expression group as i have made one in this sample

Re: Stacked chart representation

Tue, 11 Feb 2014 12:28:27 GMT

Thanks sujeet.

Re: Stacked chart representation

Wed, 12 Feb 2014 11:34:57 GMT

Hi Sujeet,

Looks like the numbers are wrong in the calculation.can you please check.

The stacked representation shows B as 700. while i am looking to represent C as sum of A and B in the stacked representation and D by the side. and moreover the dimensions are now changed to revenue type rather than quarter. I am looking at quarter based dimension.

Can you please help.

Re: Stacked chart representation

sujeetsingh — Wed, 12 Feb 2014 11:37:23 GMT

Aditya ,

Can you post your sample my one is showing correct data .

Re: Re: Stacked chart representation

Wed, 12 Feb 2014 11:42:06 GMT

can you have a look at the value for B for stacked representation its showing 700.Which should be shown under C as 490.(140+350)