Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Expression Building

Is there any kind of documentation for building expressions.  The builder itself is very limited. 

For example I want to add a count that is based on the value in a field.  I see an example of this in one of the canned applications.  But I can't figure out what it is actually doing.  I tried to replace the fields in it with mine but it doesn't work.

Here is the expression I am trying to get to work.  I want a count of Numbers where the status is not equal to 4.

Count( {$<CASESSTATUS -={'4'} >} Distinct %NUMBER)

1 Reply
maxgro
MVP
MVP

all CASESSTATUS except 4

Count( {$<CASESSTATUS =-{4} >} Distinct %NUMBER)


all CASESSTATUS of the selection except 4

Count( {$<CASESSTATUS -={4} >} Distinct %NUMBER)


you can find some help

- in Qlik online help looking for set analysis

- in the attachment

- tools qlikblog at      (add dots)