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]

Try as search-expression: =DueDate>today()

- Marcus

[shamitshah]

Hi Marcus,

I entered the following under Select In Field in the Actions tab in Button properties but it did not seem to work:

Field - OrderedUnits

Search String  - =DueDate>today()

Thanks

Shamit

[marcus_sommer · Accepted solution]

If this didn't work it's mostly caused by the formattings - you need to apply an additionally date-function like:

=DueDate>date(today())

     or

=DueDate>date(today(), 'YourDueDateFormat')

Edit: within a button you need to wrap it in single-quotes: ='=DueDate>date(today())'

- Marcus

[tamilarasu]

Hi Shamit,

Try like,

Field                ->  OrderedUnits

Search String  ->  =DueDate & '>' & Today()

[shamitshah]

Hi Guys,

I tried the suggestion from Marcus(='=DueDate>date(today())') and it works.

Thanks guys!

[shamitshah]

Guys,

Just another twist to the above. Trying to get the flip side of the expression that worked (='=DueDate>date(today())') i.e. now want to pick all items that do not have a due date, meaning that there are no outstanding orders.

I included Select Excluded, but that now picks all the items.

Any ideas?

Thanks

Shamit

[Anonymous]

Close this thread by selecting helpful/Correct answer

[marcus_sommer]

Try: ='=len(trim(DueDate))=0'

- Marcus

[shamitshah]

Tried the above but it is picking up all lines as opposed to lines that do not have a due date.

Thanks

Shamit