topic Re: Stacked bar chart in QlikView

Stacked bar chart

Mon, 25 Mar 2013 11:54:24 GMT

Hi,

I have the tables attached ( where for clarity I have deleted the dimension rows as they are not useful for the chart I want to create).

The first table has the total, while the second is filtered by the value Sex='F' and the third one by the value Sex='M'

From that table/data I want to create a chart with stacked bars as the one I have attached.

However I cannot create that, as the dimensions I want to put on x axis are, in reality, expressions:

Exp1 =Sum ({<[Soc]={'001'}>}[cost 1])

Exp2 =sum({<[Class]={'C'}>} [sales 1])

Is there a way to achive that?

many thanks in advance,

Re: Stacked bar chart

Mon, 25 Mar 2013 14:26:54 GMT

Hi,

Maybe this can help because I'm not sure if you can see what you want.

Re: Stacked bar chart

Mon, 25 Mar 2013 14:37:23 GMT

Hi Rebeca,

unfortunatelly, the graph you posted is not what I want. Each bar should show the percentage of male and female, so for Exp1 it's the first bar and then for Exp2 the second bar in the chart I attached.

Hope now it's more clear, otherwise I have no problems to provide more examples if needed.

thanks,

Re: Stacked bar chart

Fri, 08 Nov 2013 16:32:36 GMT

Hagakure, did you ever figure this out? I'm trying to do the exact same thing. Thanks!

Re: Stacked bar chart

mbm — Fri, 08 Nov 2013 18:36:23 GMT

Here is an example of a stacked bar chart using multiple expression.

To create this I've added an inline table with the values I wish to display as my X axis labels and used that field as my primary dimension. Secondary dimension is Sex to create the stacked bars.

The expression uses conditional logic to match the dimension with the expression I want to calculate.

Re: Stacked bar chart

Fri, 08 Nov 2013 18:47:34 GMT

Thanks!