function in a set analysis expression

[chapil]

Hy everybody, 

I want to use a syntax function in a set analysis expression :

Want to put my dimension upper() to have always maj caracter like this : 

sum( {$} < upper([DESCRIPTION]) not equal {"OK"} > isnull([DATE CHECK] )

1st pb -> function upper doesn't work like this 

2nd one > how to write <> / != not/ not equal in a set analysis expression  ? Like this -= ? 

Thanks a lot, 

[tresesco · Accepted solution]

Try like:

sum( {$ < DESCRIPTION={"=upper([DESCRIPTION]) <> 'OK' "} >} isnull([DATE CHECK] ))

[rwunderlich]

Double quotes around a value indicate a case-insensitive search. 

Not equal is = - .

So:

sum( {$ < DESCRIPTION = -{"OK"} >} isnull([DATE CHECK] ))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[uroboros]

@rwunderlichJust like Rob indicates.

[chapil]

Thanks a lot , 

and can I change now the value 'OK' by a flexible value ? for example with an another subject 

count({<[PAYMENT DATE] = {"=year([PAYMENT DATE])= '2020' "}>} distinct [DOC NUMBER]) NOT 2020 but max(year([PAYMENT DATE]))

count({<[PAYMENT DATE] = {"=year([PAYMENT DATE])=  max(year([PAYMENT DATE])) "}>} distinct [ID]) ?