topic clear specific filter upon tab selection in QlikView

clear specific filter upon tab selection

Fri, 07 Jan 2011 23:07:31 GMT

Hello,

I would like to be able to clear a specific filter when I go to another tab. The Clear Other Fields action doesn't seem to be doing that, and Clear All is not what I need.

Is there a way of doing this?

Thanks, Maria

clear specific filter upon tab selection

Oleg_Troyansky — Sat, 08 Jan 2011 02:43:13 GMT

Maria,

you can add an Action to clear a field and attach it to the "Activate Sheet" or "Deactivate Sheet" events (see "Triggers" tab of the sheet properties)

clear specific filter upon tab selection

maneshkhottcpl — Sat, 08 Jan 2011 03:51:59 GMT

Hi,

What u actualy want?

u want to clear all or few selectons?

clear specific filter upon tab selection

Sat, 08 Jan 2011 05:21:12 GMT

Hi Oleg,

I only have the option to clear all the filters with the Clear All Action. I need to clear only one or two filters.

Maria

clear specific filter upon tab selection

Sat, 08 Jan 2011 05:25:01 GMT

Manesh,

I want to clear a couple of the selections that I have previously made on another tab.

Maria

clear specific filter upon tab selection

Sat, 08 Jan 2011 06:26:39 GMT

I suppose I could use the Clear Other Fields Action and list all the filters but the ones that I need to clear. Doesn't seem like a great way of doing this since I will have to update that list if I add any other filters to the documents.

How can I add more than one field? Do I need to add another Clear All Fields Action for each filter?

Thanks, Maria

clear specific filter upon tab selection

maneshkhottcpl — Sat, 08 Jan 2011 09:35:52 GMT

Hi,

Please refer the attached document.

The macro is used to clear the selected list box, the macro activate whenever u leave the sheet.

Good Luck.

clear specific filter upon tab selection

Oleg_Troyansky — Sat, 08 Jan 2011 21:36:30 GMT

Maria,

wow, I never noticed that even though there is an Action "Select in FIeld", there is no "Clear Field" action... I'm afraid you are stuck with macros, as Manesh suggested...

clear specific filter upon tab selection

Mon, 10 Jan 2011 11:18:47 GMT

Hi,

If you want to clear a single field you can use the Select in Field action but select a blank value ie ' '

regards

Lucy

clear specific filter upon tab selection

amars — Mon, 10 Jan 2011 13:13:50 GMT


Sub CallClearField
 ActiveDocument.Fields("FieldName1").clear
end Sub
[\code]
See if this helps</body>

clear specific filter upon tab selection

Tue, 11 Jan 2011 20:53:53 GMT

Thanks to everyone for your help - all the solutions you provided worked.

Maria