Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
honeyasha
Contributor III
Contributor III

how to create the interval match and connect it to master calendar using single table

Can  any one help me to create the interval match and connect it to master calendar and i have fields as below:

Vessel Type,Type,Vessel Name,Period from,Period To, Purpose,amount,Agent, Bill No,Bill Date,GRT.

Thanks in advance.

3 Replies
Anil_Babu_Samineni

You can create Interval Match and then connect to [Bill Date] for Master calendar.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
honeyasha
Contributor III
Contributor III
Author

Thank for your response Anil.

I have  created Interval match then i connect to Bill Date in Master Calendar but i am getting Year in below format

56904

56905

56904

Please help me how to convert it to Year format .

Thanks,

Anil_Babu_Samineni

That means your Date Format is not correct, Could be the issue? Can you share sample or image for [Bill Date] in list?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful