Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
gsharma90
Contributor
Contributor

Implementation of Link Tables

Hi All,

I have requirement where i have 8 data sets with each one of them having different date granularity and i have a filter for Fiscal Year and Month, now what the users want is, if they select a fiscal year as 2016/2017 then all the months which falls under that year will be shown and likewise if a month is also selected with a fiscal year than the data set which have granularity on month and date will display the data of the selected month year while the one which have granularity on fiscal year will display complete data of that year.

To achieve this i have created a link table by creating a master calendar(Date,Fiscal Year, Month Year) and then cross joined it with all the distinct Countries values and then associating it with all the different data sets with the help of different keys. I then associated the date field in this table with the master calendar date field and then used the fields from the calendar directly in list box as filters.

Suppose, I have three data sets.

Data set 1:

CountryDurationMetric1
A2016/20171
B2016/20172
C2016/20173
D2016/2017

4

Data set 2:

CountryDurationMetric2
AApr-175
BMay-176
CJun-177
DJul-178

Data set 3:

CountryDurationMetric3
A4/1/20179
B4/2/201710
C4/3/201711
D4/4/201712

The resultant link table will look something like below

 

Country_LinkFYKey_LinkDateKey_LinkMonthYearKeyDate
AA|2016/2017A|4/1/2017A|Apr-20174/1/2017
BB|2016/2017B|4/2/2017A|Apr-20174/2/2017
CC|2016/2017C|4/3/2017A|Apr-20174/3/2017
DD|2016/2017D|4/4/2017A|Apr-20174/4/2017
AA|2016/2017A|5/1/2017A|May-20175/1/2017
BB|2016/2017B|6/1/2017B|Jun-20176/1/2017
CC|2016/2017C|7/1/2017C|Jul-20177/1/2017

I wanted to know if this is the most appropriate approach or can it be done in a more efficient way?

1 Reply
priyalshah9779
Contributor III
Contributor III

‌HI Gaurav

Approach  depends on size of the data but in your case I do see the concatenation of different fact will be the good approach because you need moth wise data on front end.