Sum value for a specific date range from date dimension

G_G — Sat, 16 Nov 2024 01:19:28 GMT

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

Re: Sum value for a specific date range from date dimension

Kushal_Chawda — Fri, 09 Oct 2020 14:16:58 GMT

@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)

topic Sum value for a specific date range from date dimension in App Development

Sum value for a specific date range from date dimension

Re: Sum value for a specific date range from date dimension