topic Bar Offset in a bar table in QlikView

Bar Offset in a bar table

urivera — Tue, 11 Oct 2011 14:56:49 GMT

Hi all,

1.- I have a bar table graphics with offset = 100%, begin at 0.

2.- Values dimension are 1,2,3,4,5,6,7...

3.- Values expresion are 85%, 95%, 45%, 125%, 145%, 89%...

I need that the legend at every point must show the value expresion (point 3) with a bar offset at 100 (point 1), I try with dual function but the figures showned are the complement : -15, -5, -55, 25, 25..., the offset must be use.

Any idea?

Thks a lot.

Ulises

Bar Offset in a bar table

Tue, 11 Oct 2011 15:09:25 GMT

Hi,

you have a bar offset if you clik on "+" of your expression.

I hope this helps you.

C u,

Stefano.

Bar Offset in a bar table

urivera — Tue, 11 Oct 2011 15:39:03 GMT

Thks Ste... in fact i have a bar offset in my table with a value = 1, then the values begin at this point but i need that the values showned are the originals, not the complement...Thks

Re: Bar Offset in a bar table

urivera — Tue, 11 Oct 2011 18:14:16 GMT

Again me...

I attached un example with 1 table with the values and 3 graphics, the first at natural way, the secodn is with the bar offset and the last with the dual function... i hope can help me.

thks.

Re: Bar Offset in a bar table

urivera — Wed, 12 Oct 2011 02:00:05 GMT

it's not posible?

Thks.

Re: Bar Offset in a bar table

urivera — Wed, 12 Oct 2011 02:01:06 GMT

not ideas?

Thks.

Re: Bar Offset in a bar table

Wed, 12 Oct 2011 02:26:39 GMT

There is no direct way, hence did as attached. Does this work for you?

Kiran.