Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Clear single field selection on sheet activate

Hi All,

Is there any way to clear a single filed selection instead clearing all on moving one sheet to another sheet.

In general actions has clear all function but there is no single field clear.

I know it is possible through macro, but I don't want to use macro for this.

help would be much appreciated.

9 Replies
Miguel_Angel_Baeyens

Hello,

Use the Selection, Toggle Select action, and set the following search string:

=chr(40) & GetFieldSelections(Field, chr(124)) & chr(41)


Hope that helps.

Not applicable
Author

Hi,

In the action "Leaving Sheet" use the following macro code:


ActiveDocument.Fields("Class").Clear


Regards.

Not applicable
Author

Hi Chenna ,

I have a simple solution,

on Sheet Leaving Actions, add an action like,

select in field, Write your Field name in the FieldName box and Dont give anything in the Search String box.

it will work. here when we are leaving the sheet, we just select the field with null value, then immediatly it will get unselected. try it once....

Not applicable
Author

Thanks Arjun, it works fine....

Not applicable
Author

Sorry (name mistake).. Arun. Smile

Miguel_Angel_Baeyens

Hello Arun,

Nice one. Sometimes the easier is the better.

Thanks!

Not applicable
Author

Hi Miguel Angel Baeyens ,

Its a great Complement from a Great Expert..

Thank u very much..

Not applicable
Author

Many thanks Arun - I had exactly the same issue.

deepakkrish
Creator
Creator

Wow it works like a magic ..

I tried the same for open sheet. 

Thanks.