Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Data model for different grains of data

Hi All,

How to create data model for the below scenario

Table1: this has data month wise

 

ccxlnamegcodemonthvalueyear
aaddgfjan332016
aaddgffeb442016
aaddgfapr552016

  Table2: this contain data semester wise

ccxlnamegcodesemestervalue1
aaddgf1100

  Master calendar:

monthsemyear
jan12016
feb12016
mar12016
apr12016
may12016
jun12016

  if i select month = jan , then this should be the output

output
ccxlnamegcodemonthvaluevalue1
aaddgfjan33100
1 Reply
Highlighted
Creator II
Creator II

Re: Data model for different grains of data

any suggestions??