topic Want help to make abar graph like attached image in QlikView

Want help to make abar graph like attached image

ananyaghosh — Mon, 11 May 2015 16:32:36 GMT

Hi,

I want to make a bar graph like attached image and have used no dimension and expression as sum(Income). So if it is 66% or 69% , then accordingly the red line will be increased or decreased along the gray line. So what I have to do? Please suggest

Re: Want help to make abar graph like attached image

Anonymous — Mon, 11 May 2015 16:35:38 GMT

It is a gauge chart, take a look.

Edit: Can be done with the bars too - use two expressions, stacked style.

Re: Want help to make abar graph like attached image

Anonymous — Mon, 11 May 2015 16:52:03 GMT

OK, here is a bar example

Re: Want help to make abar graph like attached image

ananyaghosh — Tue, 12 May 2015 02:29:04 GMT

!Hi,

I have the following data points in scripts:

[Data2]:

load * inline [

Exp

];

and used two expression as:

1st expression

sum(Expression1)/sum(all Expression1)

2nd expression

1 - (sum(Expression1)/sum(all Expression1))

and used stacked style

but did not get the exact effect. ! please help me.

Re: Want help to make abar graph like attached image

Anonymous — Tue, 12 May 2015 11:25:41 GMT

Your example works correctly - just bring the list box on the screen and make selections

(If no selections are made, you have 100%of course)

Re: Want help to make abar graph like attached image

ananyaghosh — Wed, 13 May 2015 12:03:10 GMT

I am requesting you to make a QVW on the basis of my provided data and please give me that one. otherwise I cannot understand that solutions.