topic ask.. what is syntax of "not equal to" in expression? in QlikView

ask.. what is syntax of "not equal to" in expression?

Tue, 05 Oct 2010 09:16:12 GMT

hello, newbie need help,

thank you before..

what is syntax of "not equal to" in expression??

example,

count({<cancel = {'0'}>} sales) <---- that is equal to 0

now i want to set the condition that cancel <> 0

i use,

count({<cancel <> {'0'}>} sales) <---- it doesn't work..

help me plis,

thank you so much

regards !

Miguel_Angel_Baeyens — Tue, 05 Oct 2010 09:23:24 GMT

Hi,

Use

count({<cancel -= {'0'}>} sales)

Meaning "all values for field cancel except for '0'".

Hope that helps.

Wed, 06 Oct 2010 04:05:47 GMT

thank you miquel

best regards !