Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
cabhijit
Valued Contributor

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.

Tags (1)
1 Reply
Not applicable

Filtering data of Fact using fields of two Dim tables

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

Community Browser