topic Re: Set analysis in QlikView

Set analysis

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

‌hey alla this is my case :

i have list of ida look like this

ID. PeriodDate Max interaction date

some ids has not an interaction date need to flag as 'Not contacted Client' , my expression will translate this:

if (periodedate is 6 month greater then Max interaction date or Max interaction date ,not contacted ,contacted)

date are number form

hope you can help

Re: Set analysis

vikasmahajan — Fri, 01 Jul 2016 12:01:37 GMT

PFA Document will help you to user stand Set analysis.

Vikas

Re: Set analysis

elakkians — Fri, 01 Jul 2016 12:39:32 GMT

Hi ,

Try This

if(Max interaction date > AddMonth(Perioded Date,6),'not contacted',contacted)

Re: Set analysis

HirisH_V7 — Fri, 01 Jul 2016 14:36:21 GMT

Hi ,

Check this,

By using the sample data,Creating a status column based on your requirement,

Data:
LOAD *,
IF(Num(Month([Period Date])-Month([Interaction Date]))>=6,
'Not Contacted','Contacted') as Status


 INLINE [
    ID, Period Date, Interaction Date
    1, 01/10/2016, 01/01/2016
    2, 01/07/2016, 01/01/2015
    3, 05/07/2016, 01/06/2016
    4, 01/08/2016, 01/03/2016
    5, 01/12/2016, 01/04/2016
];

Output:

HTH,

PFA,

Hriish