Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis for Start of this Week

How do I change this set analysis for start of this week?

{<WeeklyDaysBookedActivityGoals.Week={"$(=max(WeeklyDaysBookedActivityGoals.Week))"}>}

Thank you in advance!

Oneputtgirl

3 Replies
swuehl
MVP
MVP

Oneputtgirl,

what is WeeklyDaysBookedActivityGoals.Week

i.e. is it a consecutive week number (like a calendar week), or a week start date, maybe formatted differently?

Today's week number is given by week(today()), so you may just use that in your set modifier?

Not applicable
Author

My week is the start week date ie.. 05/21/2012

Can you give me the exact set analysis?

swuehl
MVP
MVP

Maybe like

{<WeeklyDaysBookedActivityGoals.Week={'$(=weekstart(today()))'}>}

if the standard date format matches the format of WeeklyDaysBookedActivityGoals.Week