topic Re: group creation in QlikView

group creation

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to create a age group in script.

I have a date field like OpenDate

so I want to create

0-30

31-60

61-90

91-120

120+

as Agegroup this as dimension I want to use in chart.

can anyone help on this?

Anil_Babu_Samineni — Mon, 26 Mar 2018 13:01:16 GMT

Why can't you use Age() directly in your script? May be Buckets

Anonymous — Mon, 26 Mar 2018 13:27:28 GMT

Hi Sony,

Use the Class function to create the groups.

For more help, follow below Qlik threads,

Thanks,

Venkata Sreekanth

jmvilaplanap — Mon, 26 Mar 2018 14:23:24 GMT

Hi,

Maybe you can use this function

Intervalmatch, with this you can create numeric intervals and check were one line is allocated.

Regards

Nagaraju_KCS — Mon, 26 Mar 2018 15:08:33 GMT

Try This,

If ( Date(Today()) - Date(Date_Field) ) <= 30, '0-30',

If ( Date(Today()) - Date(Date_Field) ) >= 31 and Date(Today()) - Date(Date_Field) <60, '31-60',

If ( Date(Today()) - Date(Date_Field) ) >= 61 and Date(Today()) - Date(Date_Field) <90, '61-90' ,

If ( Date(Today()) - Date(Date_Field) ) >= 91 and Date(Today()) - Date(Date_Field) <120, '91-120', '120+' )) ) ) as Days_Filter

soniasweety — Tue, 27 Mar 2018 06:33:13 GMT

done this way working fine

if(Opendate>0 and Opendate<=30,Dual('1-30',2),

if(Opendate>30 and Opendate<=60,Dual('31-60',3),

if(Opendate>60 and Opendate<=90,Dual('61-90',4),

if(Opendate>90 and Opendate<=120,Dual('91-120',5),

if(Opendate>120,Dual('> 120',6)))))) as agegroup;