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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to always display last 7 days in straight table? [Newbie question]

Dear all,

Have the below straight table.  I would like that irrelevant of what the user select in the various selection fields .... the straight table always displays the last 7 days from today.  How can this be achieved?

DayDateTargetActual%
Tue03-06-14100,00066,17566%
Wed04-06-14100,00068,47368%
Thu05-06-14100,00059,88960%
Fri06-06-14100,00051,02351%
Sat07-06-14052,7630%
Mon09-06-14100,00028,36528%
TotalTotal500,000326,688

Thanks

Alex

1 Reply
tresesco
MVP
MVP

Use set analysis in expression like:

=Sum({<Date={">=$(=Date(Today() -6))"}>} AmountField)