Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Create a age bucket and use it in multibox
Rgds
Anand
how can i create that?
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
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
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