Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

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