topic Lock / Unlock fields not working in Webview in QlikView

Lock / Unlock fields not working in Webview

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

I have a report that I created a "subtab" within a tab. It has a condition to switch to another sheet when you click on a link. On the second "tab", I have sheet properties to lock certain fields and then unlock and clear the fields when I leave the sheet. It works just fine until I use Webview and then the behavior seems to change and the fields stay locked.

On the "second" tab...I have triggers setup for OnActivate Sheet to select 3 fields and then lock those 3 fields. OnLeave Sheet, I have Unlock All and Clear All.

On the "first" tab...I have triggers setup for OnActivate Sheet to Unlock All and Clear All.

Any suggestions as to what I can do differently?

Re: Lock / Unlock fields not working in Webview

m_woolf — Fri, 20 Jul 2018 17:53:09 GMT

I think that in WebView the OnActivate sheet event triggers when you actually click a sheet tab, but not when you activate that sheet by another Action.

If you are switching sheets by clicking a button or text object with actions, you should be able to include the lock and unlock actions in the button.

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Fri, 20 Jul 2018 18:19:54 GMT

I tried that too, but that doesn't seem to work either.

Re: Lock / Unlock fields not working in Webview

m_woolf — Fri, 20 Jul 2018 18:31:42 GMT

It works in the Test attachment:

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Fri, 20 Jul 2018 19:06:50 GMT

That's not quite what I am trying to do. In your example, I am trying to lock the field, Test, to a value of 1 in Sheet1, but unlock and clear Test in Main.

Re: Lock / Unlock fields not working in Webview

m_woolf — Fri, 20 Jul 2018 19:13:57 GMT

Then just change the Action that I have on the Go to Main button.

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Fri, 20 Jul 2018 19:28:33 GMT

I can get it to work in your test.qvw, but I cannot get it to work in mine. Maybe it has something to do with the way I have the Text object setup. I have a variable I set to go back and forth from the sheet.

Re: Lock / Unlock fields not working in Webview

m_woolf — Fri, 20 Jul 2018 19:50:46 GMT

Are you referring to the value of the variable in any later actions? That definitely will not work.

Without actually seeing your qvw, I doubt that I can offer any other suggestions.

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Fri, 20 Jul 2018 19:58:15 GMT

Yes, in the other sheet I reference it. I unfortunately cannot provide a copy of the QVW as it is rather large and contains proprietary data.

Re: Lock / Unlock fields not working in Webview

m_woolf — Fri, 20 Jul 2018 20:00:57 GMT

Referencing in the other sheet shouldn't be an issue. Referencing it later in the series of actions on the same button won't work.

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Fri, 20 Jul 2018 20:04:11 GMT

I have two different text objects and two different sheets. These are the two text objects and the Properties for the second text object.

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Mon, 23 Jul 2018 17:56:34 GMT

Here is the best I can do at a Test application.

Re: Lock / Unlock fields not working in Webview

m_woolf — Mon, 23 Jul 2018 18:29:42 GMT

See if this is what you are after:

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Mon, 23 Jul 2018 18:33:39 GMT

The fields do not lock when I go from the Business Dashboard - EM sheet back to the Business Dashboard sheet and the Employee Performance tab.

Re: Lock / Unlock fields not working in Webview

m_woolf — Mon, 23 Jul 2018 18:56:57 GMT

Added actions to the OnLeave event for the Business Dashboard - EM sheet.

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Mon, 23 Jul 2018 19:03:29 GMT

Is this the only way to accomplish this as I have 20 other sheets within the full application...

Re: Lock / Unlock fields not working in Webview

m_woolf — Mon, 23 Jul 2018 19:25:22 GMT

I don't know of any other way.

If you have 20 other sheets, this method probably won't work either. The logic only works because there is just a single sheet to go back to.

You may be able to put the select and lock logic in a macro.

Why not just show SH01 and SH02 as tabs instead of hiding them and using buttons. Then you could use the OnActivate and OnLeave actions for the sheets.

Re: Lock / Unlock fields not working in Webview

cliff_clayman — Mon, 23 Jul 2018 20:13:11 GMT

The reason I hide them and use buttons is because I have 20 sheets and it's getting to be too much. We are actually reducing the amount of sheets by utilizing the buttons and trying to keep it from getting cluttered.

Re: Lock / Unlock fields not working in Webview

m_woolf — Tue, 24 Jul 2018 13:44:59 GMT

Maybe you could use getactivesheetid(). If you assign a variable: vActiveSheet =GetActiveSheetID()

Then you could use the OnChange variable event trigger to do your Field selections and locking.

Re: Lock / Unlock fields not working in Webview

m_woolf — Mon, 06 Aug 2018 14:23:37 GMT

Did you ever look at my last post?