topic Re: Re: How to create Interval match in QlikView

How to create Interval match

Srinivas — Fri, 30 May 2014 09:04:25 GMT

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.

Re: How to create Interval match

Fri, 30 May 2014 09:22:20 GMT

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

Re: How to create Interval match

PradeepReddy — Fri, 30 May 2014 09:53:22 GMT

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

Re: How to create Interval match

amit_saini — Fri, 30 May 2014 09:57:01 GMT

Hi Munna,

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

Thanks,

Re: How to create Interval match

Srinivas — Fri, 30 May 2014 10:25:36 GMT

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

Re: How to create Interval match

Srinivas — Fri, 30 May 2014 12:22:49 GMT

Hey Pradeep,

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

Regards,

munna.

Re: Re: How to create Interval match

PradeepReddy — Fri, 30 May 2014 12:54:28 GMT

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

Re: How to create Interval match

Fri, 30 May 2014 13:05:15 GMT

Hi Munna,

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