Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Locked fields

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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.

Miguel García
Qlik Expert, Author and Trainer
Not applicable
Author

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

Not applicable
Author

Fredrik,

Thanks for your comments.

Regards,

VK

Not applicable
Author

Mike,

Thanks for your comments.

Regards,

VK