Adding all values between a date range

[NirmalSupreme]

Hi, i'm new to Qlik

I am trying to achieve a total to arrive which is within a date range. I tried the below but not getting any result

=Sum(Aggr(sum({<CreatedDate= {">=$(=(Num(Date#(PostingDate))))<=$(=max(CreatedDate)-1)"}> } DQty), ItemName,Location))

Where am i going wrong? Looking forward to a solution as im stuck here..

[Mark_Little]

I would be looking to breaking it down to find the problem.

I would first ensure your Argument are returning as expected. Are the all dates or numbers?

Then check the set analysis, start with the greater than, then less than and combine and then add the Aggr

[NirmalSupreme]

Dates are in numbers, however i tried converting date to DD/MM/YYYY format as well, but not getting the result as expected. 

One info which i missed out is, CreatedDate is the Date selected from the date filter.