Count once if appears more then once within 30 days

[#1]

Hi All,

I have the following question.

let's say I have the following field: number,type, Billable,Activity ID and  date.

every activity ID represent a row with the fields above.

I need create a new field in the script called "Billable 2". the field will check if a certain "number" was appeared more then once with the same "type" within 30 days.

Can someone please advise? hope I was clear enough.

[Anonymous]

If you set a 0 or 1 flag in the script for when your condition is met, then in the front end dashboard objects you can use Max(YourFlag) that will thus return 1 if your criteria met 1 or more times, 0 otherwise.

[#3]

Thanks for answering. sorry I wan't clear enough. actually my question was  how can I write in the script a condition that will mark me If a certain field (the "number" field) was appeared more then once within 30 days (using the "date" field)

[chrislofthouse]

have you got a demo app?

If you want to do this in the script you might want to look at  'interval match'

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch