Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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.

8 Replies

Clear single field selection on sheet activate

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

Clear single field selection on sheet activate

Hi,

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


ActiveDocument.Fields("Class").Clear


Regards.

Not applicable

Clear single field selection on sheet activate

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

Clear single field selection on sheet activate

Thanks Arjun, it works fine....

Not applicable

Clear single field selection on sheet activate

Sorry (name mistake).. Arun. Smile

Clear single field selection on sheet activate

Hello Arun,

Nice one. Sometimes the easier is the better.

Thanks!

Not applicable

Clear single field selection on sheet activate

Hi Miguel Angel Baeyens ,

Its a great Complement from a Great Expert..

Thank u very much..

Not applicable

Clear single field selection on sheet activate

Many thanks Arun - I had exactly the same issue.