topic Re: Using Block Graphic in QlikView

Using Block Graphic

Tue, 29 Sep 2015 13:15:21 GMT

Hello everyone,

I am using a Block Graphic to show the gender of employees, but i am with a problem: it always shows the higher value in the left, as you can see below:

When i apply a filter, where Female is higher, it moves to the left hand side, as you can see below:

Is there a way that i can set the values always in the same position?

I need to show Male always in the left hand side, and Female always in the right hand side.

If is not possible, what type of graph should i use to do that?

Thanks,

Rodrigo

Re: Using Block Graphic

Tue, 29 Sep 2015 13:20:54 GMT

can you provide a sample qvw?

Re: Using Block Graphic

Tue, 29 Sep 2015 13:22:36 GMT

idea

you could possibly use set analysis and have 2 expressions - one for male and one for female

have 1 chart for each and palce accordingly

having a sample qvw will help

what about changing the sort to be Text, Z to A (diemsnion)

Re: Using Block Graphic

avinashelite — Tue, 29 Sep 2015 13:32:14 GMT

its the sorting issue:

Go to chart properties>Sort> un-check on the numeric value sort > have check on the Text>Z to A

Re: Using Block Graphic

Tue, 29 Sep 2015 13:45:26 GMT

I think Block Charts doesn't have the sorting tab in the Chart Properties.

At least i am not finding.

Re: Using Block Graphic

Tue, 29 Sep 2015 13:48:37 GMT

you are correct - what about 2 block charts side by side - using set analysis - one for male and one for female

or possibly 1 block chart with 2 expressions using set analysis - do not use block charts a lot myself

a sample qvw will help as well

Re: Using Block Graphic

Tue, 29 Sep 2015 14:10:00 GMT

Hi Adam,

Attached is the qvw and xls.

Thanks,

Re: Using Block Graphic

Tue, 29 Sep 2015 14:39:23 GMT

see updated version - made a copy of your block chart but display as a table and removed all of the lines - sorted from Z to A - you can then place your images above the table

this is one way to do it

did not look at all of the code so not sure how you are getting percent but set analysis for just male and then female can work as well

you can also do something similar using set analysis with text boxes and alsways having the male on the left and the images above

Re: Using Block Graphic

Tue, 29 Sep 2015 16:57:15 GMT

Rodrigo

since block charts can only ahve 1 expression, I suggest you look at something like the table method, text boxes, using set analysis to ensure that one expression will always have a male count and the other expression will have the female count