Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Age Buckets.qvw

Arjunarao
Honored Contributor II

Age Buckets.qvw

Hi,

Please find the details to create Age Bucket.

Customer_Age:

LOAD *,

if(Age >=0 and Age<=19,Dual('0-19Yrs',10),

if(Age>=20 and Age<=25,Dual('20-25Yrs',20),

if(Age>=26 and Age<=35,Dual('26-35Yrs',30),

if(Age>=36 and Age<=45,Dual('36-45Yrs',40),

if(Age>=46 and Age<=65,Dual('46-65Yrs',50),

Dual('>65Yrs',60)))))) as AgeFrame;

LOAD * INLINE [

Customer_Name,Age

Name1,25

Name2,18

Name3,20

Name4,35

Name5,40

Name6,17

Name7,8

Name8,10

Name9,15

Name10,28

Name11,43

Name12,48

Name13,60

Name14,65

Name15,70

Name16,84

Name17,89

Name18,91

Name19,26

Name20,32

];

Capture.JPG

Attachments
Version history
Revision #:
1 of 1
Last update:
‎09-04-2015 10:44 AM
Updated by: