topic Select & Lock selection in the script in QlikView

Select & Lock selection in the script

Tue, 15 Feb 2011 14:57:53 GMT

Dear all,

I've developed a QV file with information based on the last 5 years and organised by region/market/...

I would like the year to be selected and locked when I reload the data.

Is there a simple way to have this integrated in the script. I tried the following but (of course) it didn't work.

ActiveDocument.Fields("PERIOD_ID").Select "2010";

ActiveDocument.Fields("PERIOD_ID").Lock;

Thanks for your help

Select & Lock selection in the script

Tue, 15 Feb 2011 15:19:09 GMT

Hi,

Try this.

Access Tools > Edit Module copy and past this code.

Sub SelectAndLock

ActiveDocument.Fields("PERIOD_ID").Select "2010"

ActiveDocument.Fields("PERIOD_ID").Lock

End Sub

Click in Check and OK.

After, Access Settings > Document Properties > Triggers > OnPostReload add action External for Run the Macro.

Select & Lock selection in the script

Tue, 15 Feb 2011 15:32:18 GMT

Hi Fernando

Thanks a lot for the quick reply.

It looks OK. And what if I want to have a multiple selection (e.g 2009 AND 2010).

Should I write select (2010, 2009) ? It seems that it is not recognised as a value list.

Rgds

Select & Lock selection in the script

Tue, 15 Feb 2011 15:39:13 GMT

Hi,

You can trys this.

ActiveDocument.Fields("PERIOD_ID").Select "(2010|2009)"

Select & Lock selection in the script

Tue, 15 Feb 2011 16:09:53 GMT

Yes, it is working. Except when there is a partial reload triggered from a macro.

Thanks again for your reactivity

Select & Lock selection in the script

Tue, 15 Feb 2011 16:56:05 GMT

Hi Fernando,

Is there a simple way to execute the macro (Selectandlock) after the partial reload.

On my file the macro (Selectandlock) is working properly after a full reload but not the partial reload.

And the partial reload is deselecting my field even when locked.

Any idea to solve this problem?

Thanks again

Select & Lock selection in the script

Tue, 15 Feb 2011 17:50:24 GMT

I don´t know.

You try put in OnOpen the Run Marcro.

Select & Lock selection in the script

Tue, 15 Feb 2011 18:06:04 GMT

Yes, I put them on OnOpen and OnPostReload but no result....

Select & Lock selection in the script

Tue, 15 Feb 2011 18:08:51 GMT

Remove from OnPostReload, only OnOpen.

Select & Lock selection in the script

Wed, 16 Feb 2011 14:04:22 GMT

Hi Tony,

I don't want to waste your time. But just to inform you that even with OnOpen I have the same result, i.e. selection is lost and I'm not able to select Years anymore, I have to go for a full reload.

Rgds

Select & Lock selection in the script

Wed, 16 Feb 2011 16:40:26 GMT

If I understand correctly, you have a macro that does a partial load.

You can Try this:

Sub PartialReload
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.Fields("PERIOD_ID").Unlock
ActiveDocument.Fields("PERIOD_ID").Clear
ActiveDocument.PartialReload
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.Fields("PERIOD_ID").Select "(2010|2009)"
ActiveDocument.Fields("PERIOD_ID").Lock
ActiveDocument.GetApplication.MsgBox("Partial Reload")
End Sub