Current Week Selection on opening QVW

[haneeshmarella]

Hi guys,

I am trying to get the current week selection on opening my QVW file.

I have a date field DATE and week field WEEKSTART.

I have tried the following method but it does not work:

Settings > Document Properties > On Open > Add action > Add > Selection > Select In Field > Entered WEEKSTART in Field and tried

WEEKSTART(today()) or maxstring(WEEKSTART) but it does not work.

How do I achieve this? Is there any other way?

[Nicole-Smith]

Make sure you put an = in front of your expression.

Working example:

[haneeshmarella]

Nicole,

I did that but it did not work.

[trdandamudi]

What is the value in "WEEKSTART" ? Can you please check and see if the values are blank ?

[haneeshmarella]

No values are blank. They are the week start dates as in screen shot.

[Nicole-Smith]

It may have to do with the format of your dates.  Can you please attach a sample QVW so we can help you better?

[trdandamudi]

Can you please look into the attached sample file and see if it works for you:

[haneeshmarella · Accepted solution]

Found my problem, It's more of the expression problem, I used WEEKSTART(today()) or maxstring(WEEKSTART) as stated in question, but the right one which works is

MAX(WEEKSTART) and also the WEEKSTART filter had to be cleared before closing the file, and on reopening it gives the current week selection.

Thank you for your replies Nicole.

[haneeshmarella]

Used the wrong expression, it works with MAX(WEEKSTART) and also the WEEKSTART filter had to be cleared before closing the file, and on reopening it gives the current week selection.

Thank you Thirumala.

[haneeshmarella]

Being an MVP, would you happen to know how I could export a chart from my dashboard into excel using the script editor and not macros? I have many charts, but I would like to export only one particular chart among them, any idea?