Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Range of values

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

5 Replies

Range of values

Hi,

Create a age bucket and use it in multibox

Rgds

Anand

Not applicable

Range of values

how can i create that?

Range of values

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

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

SunilChauhan
Esteemed Contributor

Range of values

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