topic Range of values in QlikView

Range of values

Sat, 15 Oct 2011 00:14:16 GMT

Hi,

I have a table with

user names and Age

and i wish to have on my multibox a range of ages instead of the way it shows now (see attached file)

anyhow, is there a why to add a value range or do i need to add a new table etc.?

(I am working with sql server and not excel sheets)

10x a million.

Yaya

Range of values

its_anandrjs — Sat, 15 Oct 2011 03:58:31 GMT

Hi,

Create a age bucket and use it in multibox

Rgds

Anand

Range of values

Sat, 15 Oct 2011 12:19:18 GMT

how can i create that?

Range of values

its_anandrjs — Sat, 15 Oct 2011 12:31:25 GMT

Hi,

If you load your age field as autogenerate like and connect it with your date field

set MinAge = 1;

set MaxAge = 100;

Age:

LOAD $(MinAge)+recno()-1 as Age

AUTOGENERATE $(MaxAge)-$(MinAge)+1;

Rgds

Anand

Re: Range of values

its_anandrjs — Sat, 15 Oct 2011 12:37:52 GMT

Hi,

See the attached sampl file i suggest you have to use some thing like that,

And if any field there is no data then it shows "-" this symbol in this case so use Suppress When Value is Null.

Load some thing like this

set MinAge = 1;

set MaxAge = 100;

Age:

LOAD $(MinAge)+recno()-1 as Age

AUTOGENERATE $(MaxAge)-$(MinAge)+1;

Data:

load * inline

[

Age,Name

24,Ajay

45,Neil

12,Sanjay

17,Prakash

1,Vijay

48,Sanjay

24,Jeeven

];

Let me know about that.

Rgds

Anand

Range of values

SunilChauhan — Sat, 15 Oct 2011 14:00:30 GMT

in multi box inpace of age

you can write

class(Age,n) ,

n will any thing you want

if u want at interval of 5

class(Age,5)

1-5,5-10,10-15 and so on

or else you can use if condition like

if (age>=1 and age<=5,'1-5',if(age>5 and age<10,'5-10') and so on...

thanks

Sunil Chauhan