Section Access - Unlock Field

[fsimoes81]

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?

[DavidFoster1]

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

[fsimoes81]

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.

[DavidFoster1]

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

[fsimoes81 · Accepted solution]

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.

[DavidFoster1]

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

[jaimeaguilar]

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

[fsimoes81]

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.