Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rajendras
New Contributor III

Interval Match Question

Hi,

I have doubt regarding Interval Match in Qlikview Is there any option to check in the tool or we can manually write Keyword in the script to use the Interval Match function. Please suggest.

Thanks.

5 Replies

Re: Interval Match Question

Check this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MindaugasBacius
Valued Contributor III

Re: Interval Match Question

IntervalMatch by itself only creates a bridge between two tables.

By Joining the tables you can get one table.

rajendras
New Contributor III

Re: Interval Match Question

Yes, I am asking about this keyword IntervalMatch (Date) in the script.We have to manually write this in the script.

correct?

Re: Interval Match Question

Yes

And make sure to reply same to whom you want to talk. Then, only we can understand.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
kalyanivintha1
Contributor II

Re: Interval Match Question

Hi,

when you are trying ti write interval match function.....the qlikview is going to suggest the function there you can select the IntervalMatch function,

no need to write,

or

if you wan't to write ....write  IntervalMatch manually by your self..you can write Function.....must be Start with Cap's letter in both the words without any spaces you have to write.

and if your apply IntervalMatch on any filed

you have to write that filed  in function only otherwise it is not going to work....

you have to write like this.....IntervalMatch(Your Field Name)

Thanq.