topic Action to clear fields in QlikView

Action to clear fields

hopkinsc — Tue, 04 Jun 2013 08:19:15 GMT

Hi all,

I need to set up an action on some buttons to clear some fields, eg..

i need to clear the following fields

WO_RespondByDate

WO_RespondByMonth

WO_RespondByYear

WO_RespondByQuarter

WO_RespondByPeriod

WO_RespondByDay

I know i can list these individually and set up 6 actions but i was wondering if there was a way i can use something like the wildmatch function which will just clear any field starting with WO_RespondBy*

Is this possible or do i need to list them seperately.

I'm not sure if having more actions will affect the performance (i already have 5 actions on the button)

Thanks in advance

Re: Action to clear fields

hopkinsc — Tue, 04 Jun 2013 09:43:41 GMT

anybody have any ideas?

Re: Action to clear fields

hopkinsc — Tue, 04 Jun 2013 09:56:15 GMT

hi, thanks for the reply. but thats not what i want.

i have 4 buttons that relate to different date fields.

RespondByDate

CompletedDate

RaisedDate

SoldDate

when the CompletedDate button is clicked it passes the values of the 6 static date fields (from a date island) Date, Month, Year, Period etc to 6 variables then theres more actions that that assign the variable values to the CompletedDate Fields (CompletedDate, CompletedMonth, CompletedYear etc). the problem i have is that if i first make selections and select completedDate, i will have current selections on the completedDate fields, if i then click RaisedDate, i will then have selections on both CompletedDate and RaisedDate whereas i would only want selections on RaisedDate.

So i need to have an action that will clear all selections on the CompletedDate fields before applying them to RaisedDate.

Does that make sense?

Re: Action to clear fields

Tue, 04 Jun 2013 10:02:15 GMT

Try like this

Create a macro by specifying the clear filelds and call the macro from the button click.

Eg:

Sub ClearSpecificFields //Call this macro from a button clcik
ActiveDocument.Fields("WO_RespondByDate").ClearAll
ActiveDocument.Fields("WO_RespondByMonth").ClearAll
ActiveDocument.Fields("WO_RespondByYear").ClearAll
ActiveDocument.Fields("WO_RespondByQuarter").ClearAll
ActiveDocument.Fields("WO_RespondByPeriod").ClearAll
ActiveDocument.Fields("WO_RespondByDay").ClearAll
End Sub

Hope it will solve your problem.

Regards

===========

Kumar

Re: Action to clear fields

hopkinsc — Tue, 04 Jun 2013 10:09:17 GMT

Hi, thanks for your reply.

The macro really is no different then setting up individual actions.

I thought there might have been a way to use a function like the wildmatch that will clear all fields starting with WO_RespondBy*

Thanks anyway

Re: Action to clear fields

Tue, 04 Jun 2013 10:44:12 GMT

I don't think you can use wildmatch in this case.

But I doubt it would the performance would be better even if you could

Re: Action to clear fields

hopkinsc — Tue, 04 Jun 2013 10:52:45 GMT

ok thanks, i will just creat seperate actions

Re: Action to clear fields

yakir_manor — Sun, 08 Oct 2017 13:51:08 GMT

this can be annoying, i wrote a code that will only clear the fields that are selected, you can check this qvw, this also allows you to just list those fields in an island instead of repeating code.