topic Set analysis Last 6 month in QlikView

Set analysis Last 6 month

mario-sarkis — Wed, 12 Aug 2015 14:37:14 GMT

Hey,

my question is the following:

i have a data that contain :

ID Interaction-date

x 12/31/2014

w 2/3/2015
e 11/3/2014

y 3/3/2015

u 2/3/2014

o 8/3/2015

p 5/5/2015

PS :My date form is like this not number

i need to this show a list that show only the id that i didnt had and interation with in the las 6 months , and i need to show their count into a text box.

Thank you

Re: Set analysis Last 6 month

richard_chilvers — Wed, 12 Aug 2015 14:45:50 GMT

Hi Mario

This should be fairly straight-forward but you first need to decide what you mean by last 6 months?

Today is 12 August, so do you mean any date in August, July, June, May, April, March ?

Re: Set analysis Last 6 month

mario-sarkis — Wed, 12 Aug 2015 15:04:04 GMT

Yes Richard i need to show LIST of ID that their interaction-Date is less then March and a TEXT BOX coutn these iDs,

How to calculate and show this?

Thank you ,

Re: Set analysis Last 6 month

Anonymous — Wed, 12 Aug 2015 15:11:39 GMT

Hi Mario,

Try this out

=only( {< [Interaction-date] = {'<=month(today())-6'}>} ID)

Re: Set analysis Last 6 month

richard_chilvers — Wed, 12 Aug 2015 15:15:49 GMT

Yes, that's the idea, but it would compare a date with a month and not perhaps be so good. I'd prefer to use the MonthStart() function which gives the date of the first day of a month.

Re: Set analysis Last 6 month

Anonymous — Wed, 12 Aug 2015 15:27:28 GMT

Perhaps something like this then.

=only( {< [Interaction-date] = {'<=date(addmonths(today(),-6))'}>} ID)