How to create Interval match

[Srinivas]

Hi All,

Here i have two Query's.

1.Based on my excel i can't able to create Interval Match,I hope we have start date and end date then we can able to create Interval match.

2. Used same excel and create buckets could you please explain how to create Buckets based on this excel.

Please help on this as soon as i am waiting for your reply.

Thanks and Advance ,

Munna.

[#2]

Intervalmatch helps to "join" 2 tables, where first has range definitions (for example date_from and date_to) and 2'nd table has list of values (for example dates in calendar).

I found in your excel date field, but not date ranges.

regards

Darek

[PradeepReddy]

1) To create interval match, there is no  start date and end date fields in the sheet which you provided.

2) We can create the buckets using

     a) IF-ELSE Clause

     b) Class Function

[amit_saini]

Hi Munna,

Please see the attachment, it will hep you to understand the concept and script behind interval match.

Thanks,

AS

[Srinivas]

Yes Dariusz,

We don't have that range fields but we should divide to based on excel date field and using today date function to create 'Today to previous 30-days' is one Bucket and

previous 31-days to previous 60-days is second Bucket and

previous 61 to 90-days like way i want.Is there any possible to create like this way.

Could you please help on this.

AdvanceThanks

Munna

[Srinivas]

Hey Pradeep,

Could you explain more or do you have any sample application please share me that would be more help full.

Regards,

munna.

[PradeepReddy]

Interval Match:

  From QlikView Help menu, you can find a simple example.

Buckets Creation:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/25/which-conditional-functions-do-you-use

Find the atatched QVW file for the bucket creation.

Thansk,

Pradeep

[#8]

Hi Munna,

See the attached excel file. I have created a start and end date using simple excel formulas.