Sum value for a specific date range from date dimension
I have the following scenario.
The above two tables are linked with DATE_KEY in Qlik data model
when the user selects "MONTH_NAME" as 2016-03 in the filter , then i have to sum "Amount" for the range of START_DATE_QTD_KEY to END_DATE_QTD_KEY. i.e from 1 to 3 date key from the Table 2 , sum of amount should be 60