Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AbhijitBansode
Specialist
Specialist

Filtering data of Fact using fields of two Dim tables

Hi,

I've an requirement of filtering records of fact table by looking at relationship between 2 dimension tables.

I've attached the Excel file with this which contains the problem statement and the QVW with sample data.

Pleaes go through it and let me know how to do it in QlikView.

1 Reply
Not applicable

Abhjit,

Just include the date in the fact table and create a master calendar for the date selection.

There are several posts relating to calendars on this board.

Hope that helps