topic Re: Clear the field in QlikView

Clear the field

brindlogcool — Tue, 24 Jul 2012 14:17:24 GMT

Hi,

How to clear the selection of the specific field using trigger.

Re: Clear the field

Nicole-Smith — Tue, 24 Jul 2012 14:19:23 GMT

You need to add multiple actions (in QV9 at least) to the trigger in order to clear one selection:

Lock All

Unlock Field (the field you want to clear)

Clear All

Unlock All

Re: Clear the field

Miguel_Angel_Baeyens — Tue, 24 Jul 2012 14:20:01 GMT

Hi,

Use any of the available triggers in the Settings menu, Document Properties, Trigger, by adding a new action type Selection, Clear Field. (Available in version 11).

Try first with a button that triggers the action manually when you click on it just to make sure it works.

Hope that helps.

Miguel

Re: Clear the field

Tue, 24 Jul 2012 14:20:40 GMT

Add Trigger >

Selections

Clear Field

Enter field name

BAM! done

Re: Clear the field

brindlogcool — Tue, 24 Jul 2012 17:12:16 GMT

Hi,

Thanks for all your responses. i am using QV 10 SR4. And i got the solution from the community as

In the Sheet Triggers -Actions --Select field Name of the field to be cleared as Blank. it is working fine.