Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi Munna,
Please see the attachment, it will hep you to understand the concept and script behind interval match.
Thanks,
AS
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
Hey Pradeep,
Could you explain more or do you have any sample application please share me that would be more help full.
Regards,
munna.
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
Hi Munna,
See the attached excel file. I have created a start and end date using simple excel formulas.