Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner
Partner

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










0 Replies