topic Re: Histogram with multiple expressions. in QlikView

Histogram with multiple expressions.

Wed, 27 Feb 2013 14:44:22 GMT

Hello all,

I had a question, and I am not sure if this is possible to do within Qlikview.

This chart will look like bar charts put together sideways on the same dimensional axis (age range) and information on gender.....

Here is a rough visual of what I want.

Male Female

XXXX I <20 I XXX

XXXXXXXX I 21-30 I XXXXXX

XXXXXXXXXX I 31-40 I XXXXXXXXXXX

XXXXXXX I 41-50 I XXXXXXXXXXXXX

XXXXX I 51-60 I XXXX

XXX I >61 I XXX

Now, I cant do this combinding two barcharts and having one of them being negative values, because then they will not share the same dimensional axis (age range) which could vary between genders depending on user selections made on other fields.

Also, when the user clicks on say the age range of '21-30', I want information for both genders to show up. I also need the user to be able to click one of the Male information bars and consequently filter out the Female information bars, and vice versa.

Currently, the closest Ive gotten would be to have side by side bar chart, but then you cannot separate by gender, you can only filter down by age range.

If anyone has any suggestions on how to do this or has a workaround, that would be great.

Re: Histogram with multiple expressions.

Gysbert_Wassenaar — Wed, 27 Feb 2013 15:13:05 GMT

You could try using a straight chart with inline bars. See attached example. You'd use two expressions, one for male and one for female. In a straight table you can put the dimension with the intervals in the middle by dragging that column to the right place.

Re: Histogram with multiple expressions.

nicolett_yuri — Wed, 27 Feb 2013 15:25:59 GMT

You must follow the same idea, using two bar graphs, one with positive values and the other with negative.

The problem of hiding when no value can be solved unchecking hide zeros and checking the zero bars.

Dimensions:

In the graph dimension using only age

Expressions:

sum( {$<Gender = {"Female"}>} Amount ) for Female Graph

sum( {$<Gender = {"Male"}>} Amount ) * -1 for Male Graph

When the user clicks on the bar, he is filtering only the age, so the filter will work for the two graphs.

Re: Histogram with multiple expressions.

Wed, 27 Feb 2013 16:03:17 GMT

Thank you for the reply. However, while you can filter on age, you cannot have them filter by gender as well since its coded into the set analysis. I dont want to implement conditional shows with multiple charts, but I feel that may be the only way.

Re: Histogram with multiple expressions.

Wed, 27 Feb 2013 16:04:49 GMT

That was a very nifty solution, thank you. It still would not be able to filter by gender if I apply it to my case, but its a better solution IMO than two bar graphs conjoined.

Re: Histogram with multiple expressions.

Gysbert_Wassenaar — Wed, 27 Feb 2013 18:33:18 GMT

If you have a field for gender than the expressions can make use of that field. And if you use QV11 the gender field could also be used to show/hide the expressions depending on the selection made if you need that.

Re: Histogram with multiple expressions.

Wed, 27 Feb 2013 21:58:20 GMT

This is what I was looking for, thank you.

Re: Histogram with multiple expressions.

amien — Sun, 03 Mar 2013 22:12:36 GMT

Briliant. Thanks!