How to clear a particular Field alone from the current selection box

Mon, 02 May 2011 08:57:49 GMT

Hi Guys,

I have a macro to get the selected date range in the current selection box.

Now the problem is,on open the date range is properly getting reflected in the selection box.

After that when I change the date the selection box is not getting updated with the latest selection

It has been observed that the refresh for the date field is not happening

If I do a "ActiveDocument.clearall" in the macro,It will clear all the selections.

But what I want is all the selections has to be retained and only the date filed alone should be cleared when the macro is triggered.

Can anybody suggest the macro part to clear a particular field alone?

Thanks..

How to clear a particular Field alone from the current selection box

Anonymous — Mon, 02 May 2011 10:20:56 GMT

I don't know much about marco's, but if you use this macro in a button I got a slution;
Just add 2 actions to this button

Action 1 Select value is field
Field = Fieldname
Value = *

Action 2 Select Excluded values
Field = Fieldname

This way you first select everything in this field and then erase that selection>

I hope this is a solution for you.

topic How to clear a particular Field alone from the current selection box in QlikView

How to clear a particular Field alone from the current selection box

How to clear a particular Field alone from the current selection box