Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
has75042
Creator
Creator

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
Specialist
Specialist

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

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

View solution in original post

1 Reply
andrey_krylov
Specialist
Specialist

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

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