topic Field and Search String properties in Button Box in QlikView

Field and Search String properties in Button Box

shamitshah — Mon, 15 Feb 2016 08:34:56 GMT

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!

Re: Field and Search String properties in Button Box

marcus_sommer — Mon, 15 Feb 2016 16:19:33 GMT

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

- Marcus

Re: Field and Search String properties in Button Box

shamitshah — Mon, 15 Feb 2016 22:41:55 GMT

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

Re: Field and Search String properties in Button Box

marcus_sommer — Tue, 16 Feb 2016 07:52:18 GMT

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

=DueDate>date(today())

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

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

- Marcus

Re: Field and Search String properties in Button Box

tamilarasu — Tue, 16 Feb 2016 08:17:32 GMT

Hi Shamit,

Try like,

Field -> OrderedUnits

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

Re: Field and Search String properties in Button Box

shamitshah — Tue, 16 Feb 2016 09:50:53 GMT

Hi Guys,

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

Thanks guys!

Re: Field and Search String properties in Button Box

shamitshah — Tue, 16 Feb 2016 12:24:14 GMT

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

Re: Field and Search String properties in Button Box

Anonymous — Tue, 16 Feb 2016 12:31:59 GMT

Close this thread by selecting helpful/Correct answer

Re: Field and Search String properties in Button Box

marcus_sommer — Tue, 16 Feb 2016 14:13:07 GMT

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

- Marcus

Re: Field and Search String properties in Button Box

shamitshah — Wed, 17 Feb 2016 00:07:26 GMT

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

Thanks

Shamit

Re: Field and Search String properties in Button Box

marcus_sommer — Wed, 17 Feb 2016 08:12:01 GMT

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

Re: Field and Search String properties in Button Box

tamilarasu — Wed, 17 Feb 2016 08:12:06 GMT