topic Re: Current Week Selection on opening QVW in QlikView

Current Week Selection on opening QVW

haneeshmarella — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Current Week Selection on opening QVW

Nicole-Smith — Tue, 14 Aug 2018 14:58:59 GMT

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

Working example:

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 15:14:27 GMT

Nicole,

I did that but it did not work.

Re: Current Week Selection on opening QVW

trdandamudi — Tue, 14 Aug 2018 15:37:29 GMT

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

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 15:41:32 GMT

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

Re: Current Week Selection on opening QVW

Nicole-Smith — Tue, 14 Aug 2018 16:06:58 GMT

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

Re: Current Week Selection on opening QVW

trdandamudi — Tue, 14 Aug 2018 16:12:00 GMT

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

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 16:33:07 GMT

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.

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 16:33:55 GMT

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.

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 16:35:15 GMT

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?

Re: Current Week Selection on opening QVW

Nicole-Smith — Tue, 14 Aug 2018 16:38:34 GMT

If you add a {1} in your set analysis (like in my example), you won't need to worry about clearing selections because it will select the MAX regardless of selections.

Re: Current Week Selection on opening QVW

Nicole-Smith — Tue, 14 Aug 2018 16:41:19 GMT

If you're only looking to store data into a file, you can STORE INTO (txt) the same way you would STORE INTO (qvd).

Example:

STORE TableName INTO FilePath\FileName.csv (txt, delimiter is ',');

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 16:47:13 GMT

My query usually draws lot of data, out of which I use only few fields to create a pivot table. I would like to export only that pivot table which contains various expressions that are not in the script to store it in the Excel or txt.

How do I achieve this? I want the specific pivot table as I have to email it to certain groups of people so I do not want the entire data similar to QVD to be in the Excel, if this makes sense?

Re: Current Week Selection on opening QVW

Nicole-Smith — Tue, 14 Aug 2018 16:57:07 GMT

Programmatically? You would need macros or NPrinting.

Manually? Anyone should be able to right click on the table on the server and choose export to Excel.

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 16:57:57 GMT

It's not possible through script editor? without having to use macros?

Re: Current Week Selection on opening QVW

Nicole-Smith — Tue, 14 Aug 2018 17:08:50 GMT

The only thing possible through script editor is the STORE INTO or you can execute a macro (not sure if a macro for exporting a pivot table would work in the script editor though). You may want to ask your question in a new thread.

Re: Current Week Selection on opening QVW

haneeshmarella — Tue, 14 Aug 2018 17:12:44 GMT

Thank you for your responses Nicole.