Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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

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