Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Date range selection in Text Object Properties - Select in Field

Hello,

The property set in the Text Object below returns the current week number.

qv.gif

However what I try to achieve is that the field selection does not only return the current week but also the preceding weeks.

That is, select all weeks until today.

Is there a way to achieve this?

Gerrit

1 Solution

Accepted Solutions
MVP
MVP

Re: Date range selection in Text Object Properties - Select in Field

Try

='<=$(=week(today()))'

as search string

2 Replies
MVP
MVP

Re: Date range selection in Text Object Properties - Select in Field

Try

='<=$(=week(today()))'

as search string

Not applicable

Re: Date range selection in Text Object Properties - Select in Field

This does the trick.

You are my teacher.

Again I have learned something from you today

Community Browser