topic Bar Chart pb in QlikView

Bar Chart pb

Fri, 11 Dec 2009 17:09:37 GMT

Hello,

I have a problem using ber chart, please see attach qv, the pb is explain inside.

Many thanks,

Bar Chart pb

Fri, 11 Dec 2009 19:52:11 GMT

Hi,

I hope this will be what are you waiting for.

Best regards.

Bar Chart pb

Fri, 11 Dec 2009 20:03:09 GMT

Well thanks, but no it doesn't, I want to have somethink like :

in 2000 we had 33% Female and 67 % male

in 2001 we had 35 % female and 65 % male

and do on...

Bar Chart pb

Fri, 11 Dec 2009 20:15:39 GMT

hi,

Here I'm trying again.

Best regards.

Bar Chart pb

Fri, 11 Dec 2009 20:22:55 GMT

Well well, I can't see any difference,

We should have the same total of 100% each year, the male /female % is supposed to change but not the total.

Bar Chart pb

Fri, 11 Dec 2009 20:36:18 GMT

That's done,

you should have to check no acumulate for every expression. If you wanna acumulate the values for male and female, just make a third expression with acumulate value.

Best regards.

Bar Chart pb

Fri, 11 Dec 2009 20:46:28 GMT

No, I don't think so, let's say we have :

- 2000 : 1 female 4 male

- 2001 : 3 more females (so we have : 4 female and 4 males)

I need to have : 2000 : 20% female, 80% Male

in 2001 : 50% female, 50% male

With your solution, I'll have 2000 : 20% - 80% and 2001 : 100% female.

Bar Chart pb

Sat, 12 Dec 2009 00:42:49 GMT

Not sure exactly what you want to see, take a look at this one.

Tom

Bar Chart pb

Mon, 14 Dec 2009 16:26:52 GMT

Hi Flovit,

Here you are other solution based on Tom solution.

Best regards.

Bar Chart pb

Mon, 14 Dec 2009 17:09:26 GMT

Thanks a lot it's great, just a question how do you make the value dumped inside the bar (The male %), I can't do that on my graph.

Thanks

Bar Chart pb

Mon, 14 Dec 2009 17:54:25 GMT

Hi flovit88,

Go to Expression tab, click on the 'Numbers on Data Point'.

regards,

Bar Chart pb

Mon, 14 Dec 2009 20:26:22 GMT

You also need to go to Presentations tab, middle right hand side and select "Plot Numbers Inside Segments"

Bar Chart pb

Mon, 14 Dec 2009 22:19:14 GMT

Thanks,

And what is the need to use the dual function in expression ?

Bar Chart pb

Tue, 15 Dec 2009 22:09:37 GMT

A chart will natively display the text value of a bar or point, which by default it the formatted number. However by using the dual you can put in any text value you want, while still using the number for bar or point positioning.