Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

qlik4asif
Contributor II

What is wrong in expression?

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

1 Solution

Accepted Solutions
MVP
MVP

Re: What is wrong in expression?

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

2 Replies
MVP
MVP

Re: What is wrong in expression?

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
Contributor

Re: What is wrong in expression?

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