topic Clear single field selection on sheet activate in QlikView

Clear single field selection on sheet activate

Fri, 25 Mar 2011 11:42:17 GMT

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.

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 11:52:51 GMT

Hello,

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

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

Hope that helps.

Fri, 25 Mar 2011 11:54:11 GMT

Hi,

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


ActiveDocument.Fields("Class").Clear

Regards.

Fri, 25 Mar 2011 12:31:18 GMT

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

Fri, 25 Mar 2011 12:51:40 GMT

Thanks Arjun, it works fine....

Fri, 25 Mar 2011 12:53:16 GMT

Sorry (name mistake).. Arun.

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 13:21:48 GMT

Hello Arun,

Nice one. Sometimes the easier is the better.

Thanks!

Fri, 25 Mar 2011 15:08:54 GMT

Its a great Complement from a Great Expert..

Thank u very much..

Fri, 25 Mar 2011 16:15:16 GMT

Many thanks Arun - I had exactly the same issue.

deepakkrish — Tue, 15 Sep 2020 14:26:28 GMT

Wow it works like a magic ..

I tried the same for open sheet.

Thanks.