Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

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

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 !

1 Solution

Accepted Solutions

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

Hi,

Use

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


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

Hope that helps.

2 Replies

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

Hi,

Use

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


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

Hope that helps.

Not applicable

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

thank you miquel

best regards !