topic Section Access - Unlock Field in QlikView

Section Access - Unlock Field

fsimoes81 — Tue, 05 Aug 2014 14:12:09 GMT

On my application there are one field locked, that were ok until I implement the Section Access, now, after de reduction, this field is unlocked.

I can't use OnOpen trigger to lock this field again, because most part of users access this app by Ajax.

One means to do that, is create an "welcome sheet", but wouldn't like do that. Are there another way?

Re: Section Access - Unlock Field

DavidFoster1 — Tue, 05 Aug 2014 14:20:59 GMT

What is the locked list box doing? Is it something that could be included in the section access reduction?

Re: Section Access - Unlock Field

fsimoes81 — Tue, 05 Aug 2014 14:29:53 GMT

This field indicates if invoice is "Opened" or "Paid". By default I let locked "Opened". But, in some cases, they can look paid invoices.

In reason this I can't put this field on section access.

Re: Section Access - Unlock Field

DavidFoster1 — Tue, 05 Aug 2014 14:38:41 GMT

Would triggering a select in field 'Opened' when the document opens suffice?

Re: Section Access - Unlock Field

fsimoes81 — Tue, 05 Aug 2014 14:56:09 GMT

Yes. But, when the app is started using Ajax, the OnOpen trigger, can't be used.

I think the way is use an Welcome page, and trigger the selection in field when I change the sheet.

Re: Section Access - Unlock Field

DavidFoster1 — Tue, 05 Aug 2014 15:00:53 GMT

Ermmm. Yes it can. I use it all the time.

Re: Section Access - Unlock Field

jaimeaguilar — Tue, 05 Aug 2014 15:59:46 GMT

Hi,

Do you have QlikView 10 or some early release of QlikView 11 (SR1, SR2)? This is because I remember this behaviour ocurred in this version of QV. What happened is that when reloading from a server task, QV Server unlocked and cleared all the fields with one-selected value.

This issue was later fixed in QV 11. I did a test myself and it works as expected so I think it may be the version of QV you're running,

regards

Re: Section Access - Unlock Field

fsimoes81 — Tue, 05 Aug 2014 17:02:13 GMT

Hi Jaime,

I have Qlikview 11 SR7, I updated thinking this was a bug, but not. The behaviour happens after reduction caused by Section Access, not because when it reload.

But I will to use an extra sheet, that will solve the problem.

Thank you.