topic Re: help with formula in QlikView

help with formula

SDeLa131 — Wed, 25 Nov 2020 16:16:04 GMT

trying to create a formula for pulling only orders that do not have 000 as the ending factor. The field is only 3 characters long but yet each formula I try still pulling orders that have 000.

example is backorderNu > 000 is really what I need nothing fancy.

Re: help with formula

vishsaggi — Tue, 05 Nov 2019 19:49:37 GMT

Try this?

Trim(backOrderNu) > 000

Is this field numeric or char?

Trim(BackOrderNu) <> '000'

Re: help with formula

bharathadde — Tue, 05 Nov 2019 19:53:25 GMT

if you want to limit data on the script level

Load

Ordernum

from table

where not WildMatch(OrderNum,'*000') ;