Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Visualization and Usability

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this solution

zzyjordan
Creator II
Creator II

Hi,
You can create a weekday field in your load script like: Weekday([Your date field]) as weekday,
and then you the [weekday] in the below set analysis expression for last 4 weekday average:

=Avg({$<[your date field]={">=$(=Date(Today()-28))<$(=Today())"},weekday={$(=Weekday(Today()))}>}[your measure])

Hope this helps
ZZ

View solution in original post

Who Me Too'd this solution