topic Re: Define the values based on date in QlikView

Define the values based on date

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

Please help me to define Cust IDs based on Sales Date range. Please find the source data.

EX:

<= 1 Year = Active

>2 Year = Less Active

>3 Year = Attention

Anil_Babu_Samineni — Thu, 04 Jan 2018 12:11:21 GMT

sunny_talwar — Thu, 04 Jan 2018 12:14:28 GMT

May be this

Table:

LOAD [Cust ID],

[Sales ITM],

[sales date],

If([sales date] >= AddYears(Today(), -1), 'Active',

If([sales date] >= AddYears(Today(), -2), 'Less Active', 'Attention')) as Flag

FROM

[..\..\Downloads\Inventry.xlsx]

(ooxml, embedded labels, table is Sheet1);

tresB — Thu, 04 Jan 2018 12:15:15 GMT

Try like:

if(age(Today(), [sales date])<=1, 'Active',(if(age(Today(), [sales date])<=2, 'Less Active', 'Need Attention'))) as Flag