Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
nicolai_moller
New Contributor

count values and null in expression

Hi

In my sample data I want to write an expression that counts all cases where the field 'Exp' doesn't end with 1 or 0.

I would also like the expression to return cases with empty values in the field 'Exp', so the sample data should give me 3 cases (2, 3 and 5)

Thanks

Sample data:   

   

caseExp
1  5|1
2  4|2
3  3|3
4  3|0
5
2 Replies
YoussefBelloum
Esteemed Contributor

Re: count values and null in expression

Hi,

try this on your exp expression:

=Count({<Exp={"=not match(right(Exp,1),'1','0')"}>} 1)

jaumecf23
Contributor III

Re: count values and null in expression

Hi,

Try this.

Expression 1 : =count({<Exp-={"*|0","*|1"}>}case)

Expression 2 : =concat({<Exp-={"*|0","*|1"}>}case,',')