topic vBand display options in QlikView

vBand display options

Mon, 02 Dec 2013 09:13:29 GMT

Hi,

I have a graph where is have put in a restriction using a vBand to show the age in groups of 5 days. Now the graph displays the values as;

0 <= x = 5

5 <= x = 10

10 <= x = 15

15 <= x = 20

....

I would like the values to be shown as just the top value, that is;

...

I have attached a sample file, please have a look.

Cheers,

tresB — Mon, 02 Dec 2013 09:24:48 GMT

Like this? PFA

Mon, 02 Dec 2013 09:27:23 GMT

exactly! how did you manage that?

tresB — Mon, 02 Dec 2013 09:29:42 GMT

In your calculated dimension expression, I just added subfield function like:

=SubField(class((today()-received_date), vBand),'<',3)

Mon, 02 Dec 2013 09:31:45 GMT

nice, thank you!