Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have some thoughts on how to do if you have a variable "age" which ages in different people in the file, then I would like to group these into exepel 18-25, 26-35 and so what do I do?
Not that I am aware of. QV9, QV10, QV11 works for me atleast.
Anyhow I extracted the loadscript for you, either view it in a text editor or import into QV by Open script editor -> File menu -> Open external script file and point to the qvs file.
Hi,
If you have field name Age which has all the ages, if you want to field with age group. Please use class function in qlikview.
Example: If your age field has values from 0,1,2.....60
Function: Class(Age, 10), it will separate the field as 0<=x<=10, 11<=x<=20....50<=x<=60.
Hope this helps...
Rob has put together a wonderful QV Cookbook that contains good examples on how to achive this amongst other things. You will find it here: http://robwunderlich.com/downloads/
In the cookbook check out the mapping ranges example.
A rough outline would something like:
ÅldersGrupp:
MAPPING LOAD
Low+(iterNo()-1) as Key,
Group
WHILE iterNo() <= (High - Low) + 1
;
LOAD * INLINE [
Low, High, Group
0,15,Under 16
16,35,16-35
36,55,36-55
56,65,56-65
]
;
Hello again!I
I can not get up that file, is there a particular version of QlickView I must have?
Not that I am aware of. QV9, QV10, QV11 works for me atleast.
Anyhow I extracted the loadscript for you, either view it in a text editor or import into QV by Open script editor -> File menu -> Open external script file and point to the qvs file.
Thanx