What is wrong in expression?

[qlik4asif]

Sum({<[End Date]={">= $(=Date#(Max([End Date])-6,'MM/DD/YYYY')) <= $(=Date#(Max([End Date]),'MM/DD/YYYY'))"}>}[Runtime [sec])/60

[sunny_talwar · Accepted solution]

May be try this

Sum({<[End Date]={">=$(=Date(Max([End Date])-6,'MM/DD/YYYY'))<=$(=Date(Max([End Date]),'MM/DD/YYYY'))"}>}[Runtime [sec])/60

Changes made

1) Changed Date#() to Date() function

2) Removed spaces around >= and <= in the set analysis

[praveenkumar_ma]

May be Helpful ---

Sum({<[End Date]={'>=$(=Date(Max([End Date])-6,'MM/DD/YYYY'))'},

[End Date]={'<=$(=Date(Max([End Date]),'MM/DD/YYYY'))'}>}

[Runtime [sec])/60