Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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