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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III
‎2017-09-01 10:02 AM

Expression

Calendar

Below is my calendar expression..

I am writing a query and

Dual(Year(Today()) & '/' & Week(Today()), WeekStart(Today())) AS Fiscal_Year_LastWeek 

from my calendar.qvd which gives me the result 2017/35

I want to show the previous week. How can I alter this. I've added -1 everywhere in the above expression.

I want to show the previous week 2017/34

Labels (1)
Labels
1,021 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2017-09-01 10:13 AM

May be this

Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today(), -1)) AS Fiscal_Year_LastWeek

View solution in original post

969 Views
3 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-09-01 10:06 AM

Perhaps this?

Dual(Year(Today()) & '/' & Week(Today())-1, WeekStart(Today())) AS Fiscal_Year_LastWeek

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
969 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-09-01 10:13 AM

May be this

Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today(), -1)) AS Fiscal_Year_LastWeek

970 Views
sunny_talwar
MVP
MVP
‎2017-09-01 10:21 AM

In response to sunny_talwar

Or this

Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today()-7)) AS Fiscal_Year_LastWeek

969 Views