How to handle three dates in the backend for single Date

[rkpatelqlikview]

Hi,

I have  three tables, 2 Tables is having Feb, March,April and 1 Table is having only Feb and March.

I need to show the months and Quarter in the frond end. How can i Marge this Dates in to one?

[shiveshsingh]

How do you want to merge?  You can concatenate them to form one table.

or you can use join.

[rkpatelqlikview]

Thanks for your response Shivesh.

Actually i want to make Calendar with these 3 dates.

Table a,b having

In frontend if table a,b is having feb and march and april. table c having only feb and march.

If i select april month table C also reflecting. It shouldnot be happened. HOw to map these.?

[satishkurra]

Refer attached

Why You sometimes should Load a Master Table several times

Search Recipes | Qlikview Cookbook

[rkpatelqlikview]

Thank you Satish,

Its giving the information if multiple dates are in same table

Can i proceed if the Dates are in different tables?

[venkatdabbakuti]

Canonical Date