Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik Community,
I would like to group my Products by PEDYear automatically by also using another script instead of writing the actual years.
Ideally something like PEDYear >=AddYears(Today(),-8) should give me products with PEDYear = 2015.
NRfst:
Load Product,
If( PEDYear >=2015, 'SLP Group',
IF(PEDYear <= 2014 and PEDYear >=2008, '15 Years Group',
IF(PEDYear <= 2007 and PEDYear >=1998, '25 Years Group',
IF(PEDYear <= 1997 , 'Older than 25 Years'
)))) as AgeRange
Resident [Master_Data];
Thanks in advance for any response.
Hi ,
Refer post you can create flags for respective years & make use of flags in set analysis:
Vikas