topic Re: Clear selection in multiple fields in QlikView

Clear selection in multiple fields

Mon, 08 Aug 2016 15:10:59 GMT

Hi everyone,

I'm Trying to set a triger that Clears selections in multiple fields in many places in my QV model.

Is there a way I can do this without defining a "clear field" action to each field? Maybe some kind of a concatenated string that can clear multiple fields with only one "clear field" action.

I know macro can solve this but i rather not to use it...

Thanks,

John

Re: Clear selection in multiple fields

trdandamudi — Mon, 08 Aug 2016 15:34:56 GMT

Is the clear button is not an option for what you are trying to do ?

Re: Clear selection in multiple fields

Mon, 08 Aug 2016 15:45:41 GMT

As far as I know, clear button can clear one field or all fields - not multiple

Re: Clear selection in multiple fields

Mon, 08 Aug 2016 17:05:16 GMT

folow

Re: Clear selection in multiple fields

santiago_respane — Mon, 08 Aug 2016 17:27:14 GMT

Hi,

with a combination of clear all and lock field you can achieve that.

Example: you have a field called myField that shouldn't be cleared.

Do as follows:

Create button
- Actions
  - Lock field for myField
  - Clear all
  - Unlock field for myField

Hope this helps.

Kind regards,

Re: Clear selection in multiple fields

Tue, 09 Aug 2016 06:47:25 GMT

Thanks Santiago,

This way I have to add an action to each field I want to lock, isn't it so? This is what I want to avoid from

Re: Clear selection in multiple fields

santiago_respane — Tue, 09 Aug 2016 11:43:50 GMT

Hi,

i think that you will always have to mention every field that you want to lock, but maybe this suits you better.

Create button
- Actions
  - Call LockFields Macro
  - Clear all
  - Call UnLockFields Macro

Then in your module you create two macros as follows:

Sub LockFields

ActiveDocument.Fields("Field1").Lock

ActiveDocument.Fields("Field2").Lock

End Sub

Sub UnLockFields

ActiveDocument.Fields("Field1").UnLock

ActiveDocument.Fields("Field2").UnLock

End Sub

Please let me know if this helps.

Kind regards,

Re: Clear selection in multiple fields

santiago_respane — Tue, 09 Aug 2016 12:16:11 GMT

Or maybe this one is better for you.

Create a variable with the field names to lock\unlock:

v.Fields = 'FIELD1|FIELD2|FIELD3';

Module code:

'Gets the value from specific variable passed through varName parameter

FUNCTION getVariableValue(varName)

set v = ActiveDocument.Variables(varName)

getVariableValue = v.GetContent.String

END FUNCTION

'Locks all fields in the v.Fields Variable

Sub Lock

fields =split( getVariableValue("v.Fields"),"|")

for each field in fields

ActiveDocument.Fields(field).Lock

End Sub

'UnLocks all fields in the v.Fields Variable

Sub UnLock

fields =split( getVariableValue("v.Fields"),"|")

for each field in fields

ActiveDocument.Fields(field).Unlock

End Sub

This way you'll only have to change your variable.

Please let me know if this helps you solving your issue.

Kind regards,

Re: Clear selection in multiple fields

avinashelite — Tue, 09 Aug 2016 12:35:39 GMT

Yes, If you don't need to use the macro than you need to add a action trigger for each field and specify all the values that need to be cleared ..

Re: Clear selection in multiple fields

yakir_manor — Sun, 08 Oct 2017 13:53:11 GMT

this can be annoying, i wrote a code that will only clear the fields that are selected, you can check this qvw, this also allows you to just list those fields in an island instead of repeating code.