Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
triciagdaly
New Contributor III

Clear field not working

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!

Tags (2)
1 Solution

Accepted Solutions
Highlighted
s_kunte23
Contributor III

Re: Clear field not working

Hi

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

View solution in original post

6 Replies
Highlighted
Not applicable

Re: Clear field not working

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

Highlighted
triciagdaly
New Contributor III

Re: Clear field not working

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. 

Highlighted
Not applicable

Re: Clear field not working

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

Highlighted
triciagdaly
New Contributor III

Re: Clear field not working

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

Highlighted
s_kunte23
Contributor III

Re: Clear field not working

Hi

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

View solution in original post

Highlighted
triciagdaly
New Contributor III

Re: Clear field not working

Thank you Stefan!!  That works!!!