Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

has75042
New Contributor III

Previous week

I am using this set analysis =Sum({$<[CalendarLink]={'(=vPreviousWeek)'}>}OTHours) to get my previous week data, this expression is not giving me the right result.

My variable is as follows:

=date(CalendarLink-7)

1 Solution

Accepted Solutions
andrey_krylov
Valued Contributor

Re: Previous week

Hi, Haseeb.  I think you've missed a $ sign. Try this

=Sum({$<[CalendarLink]={'$(=vPreviousWeek)'}>}OTHours)

View solution in original post

1 Reply
andrey_krylov
Valued Contributor

Re: Previous week

Hi, Haseeb.  I think you've missed a $ sign. Try this

=Sum({$<[CalendarLink]={'$(=vPreviousWeek)'}>}OTHours)

View solution in original post