topic Group variable in QlikView

Group variable

Tue, 17 Jan 2012 12:23:54 GMT

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?

Re: Group variable

Tue, 17 Jan 2012 12:37:11 GMT

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...

Group variable

Alexander_Thor — Tue, 17 Jan 2012 12:41:49 GMT

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

]

;

Group variable

Tue, 17 Jan 2012 13:16:11 GMT

Hello again!I

I can not get up that file, is there a particular version of QlickView I must have?

Re: Group variable

Alexander_Thor — Tue, 17 Jan 2012 13:21:05 GMT

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.

Re: Group variable

Tue, 17 Jan 2012 13:23:49 GMT

Thanx