topic Re: static bar width in QlikView

static bar width

Anonymous — Sun, 29 Oct 2017 05:54:20 GMT

How to do the static bar width in bar chart for example

Re: static bar width

vinieme12 — Sun, 29 Oct 2017 09:32:41 GMT

use DUAL() function

example

Dual( num(10000,'$ #,##0') , 10)

will scale the bar to height 10,,...you cannot control the width of the bar,

Re: static bar width

rubenmarin — Sun, 29 Oct 2017 09:58:32 GMT

Hi Ashok, not static but in Chart properties -> Presentation tab, you can enable the option to 'Show scrollbar on X axis', this allows to set a maximum number of elements, so the bars always have a minimum widht.

The bars can grow bigger if the chart has to paint less bars than the value set for enable scrollbar, in this case they will grow to occupy the widht of the chart.

In some charts the number of bars can be fixed (so the widht remains the same) but only a few situatons allows to apply this kind of solution.

Re: static bar width

Anonymous — Sun, 29 Oct 2017 10:08:17 GMT

Hi Ruben,

Actual my requirement is this is my data

but I want like this output

Re: static bar width

rubenmarin — Sun, 29 Oct 2017 10:20:01 GMT

In that case you can enable the option to 'Show all values' in dimension tab, and uncheck the option to 'supress zero values' in presentation tab.

Re: static bar width

Anonymous — Sun, 29 Oct 2017 10:42:58 GMT

How to derive the quarters like

Jan,Nov,Dec-Q1,Feb,Mar,Apr-Q2,May,June,July-Q3,Aug,Sep,Oct-Q4 and every quarter have 13 weeks

like week numbers Q1-1to 13 ,Q2-1 TO 13