Field and Search String properties in Button Box

[shamitshah]

Hi,

I have the following expression in a QlikView chart which I am trying to reflect in a button to select all outstanding Purchase Orders which are due (not yet delivered). The two fields are DueDate and OrderedUnits.

The expression sum(if(DueDate>Today(), OrderedUnits)) works in the chart.

Need to know what I need to enter in the Field and Search String boxes in order to make the button work. Any idea?

Thanks!

[marcus_sommer]

I have tried something similar with my data and it worked well:

='=len(trim(Close))=0' // Open and Close are dates like in many other cases FromDate and ToDate

- Marcus

[tamilarasu]