topic Block Values in a field Permanently in QlikView

Block Values in a field Permanently

Mon, 06 Jul 2009 16:55:55 GMT

Hello,

I have a Table with 2 values. I wanted them to get always locked, whenever I open my application. How can I do this. I dont want it to Block manually but Automatically so that there is no chance of removing the blocking.

The Table is

Table1:

1000,2000,3000, 4000

I wanted the 2000 and 4000 to be blocked? Is it done by writing a Macro or is there any other way??

Thanks in Advance

Sravan

AW:Block Values in a field Permanently

Mon, 06 Jul 2009 17:11:17 GMT

Document Properties > Triggers

OnOpen > Selection > Select in Field

OnOpen > Selection > Lock Field

-----------

Or with a triggered VB script:

ActiveDocument.Fields("Field").Select values
ActiveDocument.Fields("Field").Lock

Greetz

Block Values in a field Permanently

Fri, 27 May 2011 15:32:42 GMT

Sorry for bringing this old thread up.

The solution posted by driesena works but if the user continues doing further selections (in other fields) then the "Lock" condition avoids properly erasing these further selections.

In other words, I would also be interesed in finding a way to "block" a given selection, then further selections are done and pressing "Clear" would clear all selections except the blocked one.

Example: all sales team sharing the same document but depending on the user who opens the document, I want to block the field salesman to a given value. Then other selections (product group, year, month, ...) can be done but presing the clear button will clear all the selections except the one of the salesman.

Any hints?

Thanks

Block Values in a field Permanently

erichshiino — Sat, 28 May 2011 00:07:06 GMT

Hi, Carlos. I answered a post similar to this a few weeks ago.

I wanted to keep a field locked even if a user uses 'unlock and clear'

Then, I made a second version, where I can let you apply this 'setting' using a macro (you could enable and disable this)

http://community.qlik.com/message/115847#115847

Hope it helps,

Erich

Block Values in a field Permanently

Sat, 28 May 2011 06:00:11 GMT

Thanks Erich, I'll give it a try.