Master Calendar

[#1]

Hi team,

Scenario is,

I have different tables ekko,ekpo,ekbe tables, below are the respective fields in tables.

EKKO : PO , PODATE (PO and PODATE is one to one mapping)

EKPO : PO , PI , DATE(PO can have 'N' number of PI but

                                        PO+PI has one to one mapping with DATE i.e., each PO+PI have single DATE)

EKBE : PO , PI , INVOICE NUMBER , INVOICE DATE , PPDATE (PO can have 'N' number of PI and

                                        PO+PI can have 'N' number of INVOICE NUMBER's but

                                        PO+PI+INVOICE NUMBER will have one to one mapping with INVOICE DATE , PPDATE)

                                        In other words each INVOICE NUMBER has singe INVOICE DATE and single PPDATE.

How to create master calendar for the above scenario?

Thanks in advance.

[fkeuroglian]

Hi Amar

see this link, hope helps

Canonical Date

and this example too

Search Recipes | Qlikview Cookbook

Why You sometimes should Load a Master Table several times

Fernando