topic Re: not equal in expression in QlikView

not equal in expression

Wed, 26 Sep 2012 10:50:22 GMT

I need to create a where condition in an expression: shiow "STATO" when it is different to "ANNULLATO"

only({<[STATO]<>{'ANNULLATO'}>}STATO)

This expression not accept '<>'

Someone can help me?

nilesh_gangurde — Wed, 26 Sep 2012 10:53:10 GMT

Use this Expression:

only({<[STATO] -={'ANNULLATO'}>}STATO)

Regards

Nilesh Gangurde

rajni_batra — Wed, 26 Sep 2012 11:01:36 GMT

only({<[STATO]-={'ANNULLATO'}>}STATO)

only({<[STATO]={'*'}-{'ANNULLATO'}>}STATO)

uttamdwibedy — Wed, 26 Sep 2012 11:21:51 GMT

Hi, here is another one:-

if(match([STATO],'ANNULLATO')=0)

Wed, 26 Sep 2012 12:19:14 GMT

This works .... Thanks!

only({<[STATO]={'*'}-{'ANNULLATO'}>}STATO)

Wed, 26 Sep 2012 13:36:12 GMT

And if i want replace "STATO" with an operation as: CASH-COSTS how can i do?

If I write

only({<[CASH-COSTS]={'7'}>}STATO)

I receive error for CASH-COST

rajni_batra — Thu, 27 Sep 2012 04:55:09 GMT

ur expression is perfect just check if making any spelling mistake or any kind of mistake in field name

Thu, 27 Sep 2012 07:22:43 GMT

no mistake...it not accept the subtraction CASH - COSTS

rajni_batra — Thu, 27 Sep 2012 07:35:48 GMT

oh is this the subtrcation?? i thought this a field name...

i dont think this kind of subraction gonna work in set