Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Community Browser