topic Re: Stacked bar chart question in QlikView

Stacked bar chart question

Mon, 11 Aug 2014 23:25:59 GMT

So I have 1 dimension and 6 expressions...i need a stacked chart so that expr1,exp 2,exp 3 show up in 1 stacked bar and exp 4,exp 5 ,exp6 come in the adjacent stacked bar chart.. is this possible

| |exp1| |exp4|

| -------- --------

| |exp2| |exp5|

| -------- --------

| |exp3| |exp6|

----------------------------------------------------------

Re: Stacked bar chart question

ecolomer — Tue, 12 Aug 2014 03:29:50 GMT

Yes, most simple are to have another variable "Group· with 2 values possibles A y B

In the graphic you write the expressions:

exp1 = if(Group='A', exp1, Null())

exp2 = if(Group='A', exp2, Null())

exp3 = if(Group='A', exp3, Null())

exp4 = if(Group='B', exp4, Null())

exp5 = if(Group='B', exp5, Null())

exp6 = if(Group='B', exp6, Null())

and put Group in a dimension.

The bar are appiled

Re: Stacked bar chart question

Tue, 12 Aug 2014 18:05:15 GMT

Thanks got it working