topic Re: Clear field not working in QlikView

Clear field not working

triciagdaly — Wed, 12 Nov 2014 15:17:07 GMT

I am trying to clear a field, 'Receipt_WeekStart' before populating with the maximum date. I have a 'OnOpen' trigger under document properties that clears the field and then sets the value. The clear is not working. See attached screenshots.

Thanks!

Re: Clear field not working

Wed, 12 Nov 2014 15:24:42 GMT

Hi,

Plz put the clear field action after all of the actions.put it in last then it will work.here you have after clear field u can select a field action is der so thats the problem

Re: Clear field not working

triciagdaly — Wed, 12 Nov 2014 15:36:28 GMT

Putting the clear field after the other actions did not work. Now when I close and reopen the app, the date filter is blank. I need this field cleared and repopulated when I re-open the app or tab off and back onto the sheet. The only way I can get this to work is to manually clear the filter and tab off and back onto the sheet. Not what I need though.

Re: Clear field not working

Wed, 12 Nov 2014 15:39:45 GMT

Hi,

For this we need to use macro here.try to use that macro and create a action run macro.

Kindly search for that macro in community.

http://community.qlik.com/docs/DOC-4870

Re: Clear field not working

triciagdaly — Wed, 12 Nov 2014 15:50:05 GMT

I would appreciate more specifics as I'm fairly new to Qlikview and Macros.

Re: Clear field not working

Anonymous — Wed, 12 Nov 2014 15:59:32 GMT

you can do this without macro.delete the clear field trigger and try to use date(max( {1} Receipt_WeekStart)), this will ignore any selections and set the max Weekstart. Also make sure you are giving the right date format.

hope this helps

Best

Stefan

Re: Clear field not working

triciagdaly — Wed, 12 Nov 2014 16:03:20 GMT

Thank you Stefan!! That works!!!