-
Range of values
Anand Chouhan Oct 14, 2011 11:58 PM (in response to yaya7777)Hi,
Create a age bucket and use it in multibox
Rgds
Anand
-
Range of values
yaya7777 Oct 15, 2011 8:19 AM (in response to Anand Chouhan )how can i create that?
-
Range of values
Anand Chouhan Oct 15, 2011 8:31 AM (in response to yaya7777)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
Anand Chouhan Oct 15, 2011 8:37 AM (in response to yaya7777)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
-
Age-Main.qvw 119.5 K
-
Range of values
Sunil Chauhan Oct 15, 2011 10:00 AM (in response to Anand Chouhan )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
-
-
-