topic Bar Chart Expressions Order in QlikView

Bar Chart Expressions Order

cbaqir — Wed, 15 Jul 2015 16:17:48 GMT

I have a combo chart that uses grouped and stacked bars to compare Allocated vs Actual (Plus PTO) hours. I cannot seem to figure out how to get the Allocated (blue) bar before the Actual (orange and green) bars. I'm certain there must be a way. Help!

Thanks in Advance!

Cassandra

Re: Bar Chart Expressions Order

stigchel — Wed, 15 Jul 2015 16:32:01 GMT

Not sure what your dimensions and your expressions are?? Also don't think you can have mixed stacked and grouped, probably both stacked, but only 1 value(color?) for the blue one by the expression?

For an expression, you can select and just promote the Allocated Effort expression

For a dimension something like

=Match(YourDimension,'Allocated Effort','Actual Effort',.....)

Re: Bar Chart Expressions Order

cbaqir — Wed, 15 Jul 2015 16:35:45 GMT

Please see my screenshot. I am comparing Allocated (grouped) to Actual + PTO (stacked). This is accomplished by adding a flag as a dimension.

Allocated is already first in my Expression list.

Re: Bar Chart Expressions Order

stigchel — Wed, 15 Jul 2015 16:45:41 GMT

Then you can probably just sort on the Flag dimension, if the flag is a number you can sort on numeric value for that dimension, ascending or descending. When it's text use sort on expression with the expression I already mentioned, sometehing like

=Match(Flag,'Yes','No')

Re: Bar Chart Expressions Order

cbaqir — Wed, 15 Jul 2015 17:00:47 GMT

Thanks for the response.

My other dimension is a date (month/year) and that is the sort order for the x-axis. I'm new to using Flags, so please forgive my ignorance, but how would this work?

Re: Bar Chart Expressions Order

stigchel — Wed, 15 Jul 2015 18:05:48 GMT

That's ok Cassandra, select FLAG_PTO in the dimensions area, then depending on the contents of FLAG_PTO as explained in my previous post only select numeric value in the sort by section, or only select the expression and use the expression e.g. =Match(Flag,'Yes','No')

Let me know

Re: Bar Chart Expressions Order

Kushal_Chawda — Wed, 15 Jul 2015 18:20:05 GMT

Can you post sample?

Re: Bar Chart Expressions Order

cbaqir — Wed, 15 Jul 2015 20:07:31 GMT

Sample attached - I want the Allocated bar on the left and Stacked Actuals on the right

Re: Bar Chart Expressions Order

Nicole-Smith — Wed, 15 Jul 2015 20:14:11 GMT

It's because your flag is null for the values that aren't 1 and QV always sorts null values to the end.

To fix, change your dimension for Flag to:

alt(Flag,0)

And then sort your Flag dimension by Numeric Value:

Re: Bar Chart Expressions Order

cbaqir — Wed, 15 Jul 2015 20:16:17 GMT

Thanks Nicole! I haven't seen the alt function before.

Re: Bar Chart Expressions Order

Nicole-Smith — Wed, 15 Jul 2015 20:19:01 GMT

If you're familiar with SQL, it works pretty much like COALESCE().