Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
priya945
New Contributor III

Master Calendar to Fact Table Monthly,Quaterly

Hi All,

My Fact table contains Weekly,Monthly,Quaterly values as below. I want to create a Master Calendar and connect it to the fact table Weekly,Monthly,Quaterly . Please suggest how can I achieve this

Load * Inline [
Metric, Date, Frequency, Value, Flag
A , 01/12/2018, Weekly, 08,Y
B , 01/12/2018,Weekly, 10, Y
C , 01/12/2018, Weekly, 04, Y
A , -         , Monthly, 15,N
B , -         , Monthly, 20,N
C , -         , Quaterly,12, N
];

 

Thanks

4 Replies

Re: Master Calendar to Fact Table Monthly,Quaterly

What would Monthly value connect to Master Calendar table on? There is no date to know which month it is. Can you provide the master calendar table look that you are hoping to get here?

priya945
New Contributor III

Re: Master Calendar to Fact Table Monthly,Quaterly

Thanks Sunny for your time. My data is as below

Test:

Load * Inline [
Metric, Date,             Frequency, Value, Flag, Month, Qtr
A ,        01/12/2018, Weekly,          08,   Y,            12,         Q3'18
B ,        01/12/2018, Weekly,         10,   Y,             12,          Q3'18
C ,       01/12/2018, Weekly,          04,   Y,             12,           Q3'18
A ,          -                   , Monthly,        15,   N,             1,           Q4'18 
B ,          -                    , Monthly,      20,   N,              1,             Q4'18
C ,         -                     , Quaterly,     12,   N,               -,             Q4'18
];

Expected o/p as below, when Monthly filter is selected 

MetricJan'18
A15
B20

and for Quaterly Filter

MetricJan'18
C12

 

I need to create a Master Calendar for above requirement, Please help

Thank you

Re: Master Calendar to Fact Table Monthly,Quaterly

But you can get the same output without creating a master calendar. What exactly are you looking the master calendar to do here? I am missing the link here

priya945
New Contributor III

Re: Master Calendar to Fact Table Monthly,Quaterly

I need to have the Jan'18 in Month filed & Q1'18 in Qtr filed to use as dimensions rt? so  creating a Master calendar and associating with Fact table

Thank You