topic Changing/fixing bar size in QlikView

Changing/fixing bar size

Wed, 30 Sep 2015 07:00:55 GMT

Hi All,

I have requirement to fix bar size over any selection of filters

Default view:

After Filter

Expected output is to get same bar size.

1) By resizing chart dynamically

2) By fixing a bar size

But I am not finding any option to achieve above options.

Thanks

Ravi

Re: Changing/fixing bar size

marcus_sommer — Wed, 30 Sep 2015 10:46:19 GMT

This is a default-behaviour from the chart and couldn't be directly customized. The only way to get "fixed" bar-widths is to make the chart per set analysis independent from the any/certain selections and to "hide" the unrelated values by setting conditions into the various layout-settings like the background-color. Try with the expressions something like this:

color-expression:

if(count(Group) = 0, argb(0,0,0,0), blue())

chart-expression:

sum({1} Group)

Maybe you will need further adjustments to the sorting for the groups if you don't want wholes within the dimension values and put them in front or to the end from the dimension-values.

- Marcus

Re: Changing/fixing bar size

tresB — Wed, 30 Sep 2015 11:13:12 GMT

Or may be like in attached sample ?