topic set analysis not equel in QlikView

set analysis not equel

Anonymous — Tue, 26 Jul 2016 12:35:13 GMT

hay,

how do i write not equel in sat analysis

count({<orders={>0}>}packing

thanks'

yarin

sunny_talwar — Tue, 26 Jul 2016 12:37:44 GMT

May be like this:

Count({<orders = {'<>0'}>} packing)

Tue, 26 Jul 2016 12:38:05 GMT

count({<orders-={>0}>}packing

with "-="

jonathandienst — Tue, 26 Jul 2016 12:38:55 GMT

You may need quotes:

count({<orders={">0"}>}packing

but its hard to be sure without knowing your data model...

Chanty4u — Tue, 26 Jul 2016 12:39:20 GMT

try this

Count({<Orders-={>0'}>}Packing)

Chanty4u — Tue, 26 Jul 2016 12:42:04 GMT

orelse

you can use -= to exclude a value

Count({<Orders-={">0"}>} DISTINCT Packing)

saimahasan — Tue, 26 Jul 2016 13:12:06 GMT

You can use the expression:

=count({<Orders={"*"}-{"0"}>}Distinct Packing)

It will work