Expression Building

rittermd — Mon, 29 Sep 2014 20:56:45 GMT

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)

Re: Expression Building

maxgro — Mon, 29 Sep 2014 21:15:43 GMT

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)

topic Re: Expression Building in App Development

Expression Building

Re: Expression Building