Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chapil
Contributor III
Contributor III

function in a set analysis expression

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, 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

View solution in original post

4 Replies
tresesco
MVP
MVP

Try like:

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator
Creator

@rwunderlichJust like Rob indicates.

 

chapil
Contributor III
Contributor III
Author

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]) ?