topic Re: Stacked bar chart in QlikView

Stacked bar chart

manoranjan_d — Wed, 14 Oct 2015 21:23:41 GMT

Hi all,

I m using stacked bar chart, in that no dimension and i m using only expression, now i want to sort the value from low to high

how can i do that in sort tad?

pls help me

Re: Stacked bar chart

Gysbert_Wassenaar — Thu, 15 Oct 2015 05:33:35 GMT

You can't afaik. To sort a bar chart you need at leas one dimension to have values that can be sorted.

Re: Stacked bar chart

Thu, 15 Oct 2015 05:39:30 GMT

Hi,

Create a inline table int the sort order and use that.

Re: Stacked bar chart

Gysbert_Wassenaar — Thu, 15 Oct 2015 05:40:49 GMT

There are no dimension values to sort in the chart because there is no dimension. There are only expressions.

Re: Stacked bar chart

gautik92 — Thu, 15 Oct 2015 05:42:41 GMT

you cannot sort it without a dimension

Re: Stacked bar chart

nagarjuna_kotha — Thu, 15 Oct 2015 05:55:58 GMT

Its Impossible

Re: Stacked bar chart

vincent_ardiet — Thu, 15 Oct 2015 06:28:39 GMT

Hi Manoranjan,

I have found a solution but the bar chart will be horizontal:

- Create a Mekko chart

- Create a dimension with =Valueloop(1,X) where X=number of expressions you are using

- In the expression, use only one:

=pick(ValueLoop(1,X)

,<expression1>

,<expression2>

,...

,<expressionX> )

- Sort by Y-value

- Go also in the background color settings of the expression in order to make the color change regarding the expression (you can reuse the pick or create a formula mixing RGB() and ValueLoop()).

I have tested with the Funnel, it's well orienteted but in a triangle.

Regards,

Vincent

Re: Stacked bar chart

manoranjan_d — Thu, 15 Oct 2015 08:46:49 GMT

hi all,

when it came impossible means then i ll use dimension .

now i m using the one dimension and 3 expression, when i go to sort and give sort the value is not sorted and i m usin the stacked bar, please let me know how to sort the value in stacked bar chart

Re: Stacked bar chart

manoranjan_d — Thu, 15 Oct 2015 13:45:27 GMT

hi all can u pls reply me

Re: Stacked bar chart

vincent_ardiet — Thu, 15 Oct 2015 14:46:44 GMT

We already answered, it's not possible to sort expressions. If you create 3 expressions, the resulting numbers will always be displayed in the same order than your expressions.

The only solution is to have a dimension (ok you did it), but a single expression.

Then you will face another difficulty, to create a stacked bar chart with a single expression, you will need... 2 dimensions. The first one will be the x axis, the second one the dimension used to organize your stack.

Ok fine, you can create a fake dimension with a single value as a first dimension.

But, yet another joke. You can only sort the first dimension of the Y value.

Maybe it's possible to use an expression to sort on the second dimension but with the valueloop I haven't managed to do this.

With the mekko and the funnel you can have something close to want your looking for.

But finally, you can maybe compare in your expressions, all of them (if you have only 3) like =if (expr1> expr2, if(expr1> expr3, expr1, expr3), if (expr2> expr3, expr2, expr3)), if. Or use many combinations of youf expressions and use the conditional field to activate them in the proper order.

Re: Stacked bar chart

vincent_ardiet — Fri, 16 Oct 2015 11:40:13 GMT

Hi,

I you have only 3 expressions, it's feasible.

I have done a test.

- Create 3 variables containing each of your expressions, I've called them exp1, exp2 and exp3

- In the bar chart create 7 expressions containing in this order:

$(exp1)

$(exp2)

$(exp3)

$(exp1)

$(exp2)

$(exp1)

$(exp3)

- Then for each expression use the following condition to display them

$(exp1)>=$(exp2) and $(exp1)>=$(exp3)
$(exp2)>=$(exp3)
($(exp1)>=$(exp3) and $(exp1)>=$(exp2)) or ($(exp2)>=$(exp3) and $(exp1)<$(exp3)) or ($(exp1)<$(exp3) and $(exp3)>=$(exp2))
($(exp1)<$(exp2) and $(exp2)>=$(exp3)) or ($(exp1)>=$(exp2) and $(exp1)<$(exp3))
$(exp2)<$(exp3)
$(exp1)<$(exp2) and $(exp1)<$(exp3) and $(exp2)<$(exp3)
$(exp1)<$(exp2) and $(exp2)>=$(exp3) and $(exp1)>=$(exp3)

With more expresions it will become really tricky.

Regards,

Vincent