App Development

[G_G]

Hello All 

I have the following scenario.

Table1

Table 2

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

Can any one help me in this ?

Regards

G

[Kushal_Chawda]

@G_G  try below.

Create two variables on frond end like below

vSTART_DATE_QTD_KEY = max(START_DATE_QTD_KEY)

vEND_DATE_QTD_KEY =max(END_DATE_QTD_KEY)

Then try below expression

=Sum({<MONTH_NAME,DATE_KEY={">=$(vSTART_DATE_QTD_KEY)<=$(vEND_DATE_QTD_KEY)"}>}Amount)