topic Script help repeat records in QlikView

Script help repeat records

Tue, 27 Jul 2010 15:30:41 GMT

Hi,

I will try and explain my question as best i can.

I have some source data which is being loaded in to QlikView which contains details of customer contacts, such as customer number, contact date, reason etc.

The purpose of my script is to identify customers that have contacted more than x number of times in a given period (30 days), what i want to do first of all is:

1) Identify contacts where contact date is anywhere between todays date and -30 days.

2) Where a contact date is identified (eg, 29 days ago) i would like the script to look back a further 30 days (from the first identified contact date for each unique customer number) and return any additional contacts for that customer number if the 30 days previous to the most recent contact.

Any help would be appreciated.

Thanks

Script help repeat records

Thu, 29 Jul 2010 10:00:13 GMT

Anyone?

Script help repeat records

Thu, 29 Jul 2010 11:42:09 GMT

Hi,

You can create a flag in your script to identify if the contact date is between today and -30 dasy as follows,

if([contact Date]>=Today()-30,1,0)

If the flag value is '1' it means that the customer has contact within last 30 days. With this value, you can further create another flag to check the second condition.

hope this resolves your issue.

cheers Haneesh