Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gauravgg
New Contributor III

How to sum the value for specific date range?

Hi All

I have the following field in a table of data model

ValueType

Budget-FY-16

Budget FY-17

Budget FY-18

May-17

Sep-17

Jun-16

Dec-16

I also have

AmendmentData, ValueType

DD/MM/YYYY, Value

DD/MM/YYYY, Value

DD/MM/YYYY, Value

DD/MM/YYYY, Value

.

.

.

DD/MM/YYYY,Value


when the user Selects Sep-17 from ValueType field  , i want to sum the AmendValue  from starting month of that FY year  till the selected monthYear

(ie from April-17 to Sept-17)


sum(    { ?  }       ValueType  )





Can anyone help me in this?


Thanks in Advance










Tags (2)
Community Browser