Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More

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:
‎2015-09-04 10:44 AM
Updated by: