Locked fields

[#1]

Hello,

Is it possible to have locked fields apply to single tab only?

I can create a duplicate field and use it on the other tab while the main field is locked, but I just wondering if there is another way to do it.

I will appreciate some expert advice.

Best regards,

Vladimir

[#2 · Accepted solution]

Hi Vladimir

All selections made in a QV document are applied to the entire document, there is no way to apply the selections only to a single tab, at least not using standard functionality.
It would be possible to do with the use of macros set to run when each tab is activated but I wouldn't recommend that solution....

/Fredrik

[mike_garcia]

I recently downloaded a demo that has that funcionality using Macros that are run when every sheet is activated.

This is the code in the Edit Module Setion:

sub SelectClearFlag
activedocument.Fields("Cleared_Flag").Select "Open"
activedocument.Fields("Cleared_Flag").Lock
activedocument.Fields("Debit/Credit_Flag_SHKZG").Select "D"
end sub

sub SelectClearFlagLeave
activedocument.Fields("Cleared_Flag").unLock
activedocument.Fields("Cleared_Flag").Clear
activedocument.Fields("Debit/Credit_Flag_SHKZG").Clear
end sub


sub SelectClosedFlag
activedocument.Fields("Cleared_Flag").Select "Cleared"
activedocument.Fields("Cleared_Flag").Lock
activedocument.Fields("Debit/Credit_Flag_SHKZG").Select "D"
end sub

sub SelectClosedFlagLeave
activedocument.Fields("Cleared_Flag").unLock
activedocument.Fields("Cleared_Flag").Clear
activedocument.Fields("Debit/Credit_Flag_SHKZG").Clear
end sub

I don't see any problems using it. Fredrik: why wouldn't you recommend using that option? It would be interesting to understand your perspective.

Regards,

Mike.

[#4]

Hi

I don't have any objections to using macros but I think that when you use them to circumvent the default Qlikview logic it can cause a lot of confusion.
I would be very surprised if a selection I had made on one tab wasn't reflected on another. That's why I don't recommended that solution but maybe it's appropriate in certain situations.

/Fredrik

[#5]

Fredrik,

Thanks for your comments.

Regards,

VK

[#6]

Mike,

Thanks for your comments.

Regards,

VK