Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Reply
Anonymous
Not applicable
Author

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.