Discussion board where members can get started with QlikView.
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.
Create a age bucket and use it in multibox
how can i create that?
If you load your age field as autogenerate like and connect it with your date field
set MinAge = 1;
set MaxAge = 100;
LOAD $(MinAge)+recno()-1 as Age
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
load * inline
Let me know about that.
in multi box inpace of age
you can write
n will any thing you want
if u want at interval of 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...