Is this expression correct?

stevejones1 — Thu, 29 Mar 2018 16:47:51 GMT

Here is my expression to get data for past 5 weeks , i don't want to see current week's data , but with below i can see current weeks data , also i want this expression to be independent of all other selections, can some one please help me in getting correct expression.

Thank you!

CaseOpenDate = {'>$(=WeekStart(Max(Date),-5))<$(Date(WeekStart(Max(Date))))'}

Here is my complete expression :

=count({1<Indicator = {'Created'},CaseOpenDate = {'>$(=WeekStart(Max(Date),-5))<$(Date(WeekStart(Max(Date))))'},CaseType ={'TS'}>} DISTINCT(CaseNumber))

Re: Is this expression correct?

sunny_talwar — Thu, 29 Mar 2018 16:50:31 GMT

An equal sign seem to be missing

=Count({1<Indicator = {'Created'}, CaseOpenDate = {">$(=WeekStart(Max(Date),-5))<$(=Date(WeekStart(Max(Date))))"}, CaseType = {'TS'}>} DISTINCTCaseNumber)

topic Is this expression correct? in QlikView

Is this expression correct?

Re: Is this expression correct?