topic Re: count values and null in expression in QlikView

count values and null in expression

nicolai_moller — Thu, 01 Mar 2018 09:33:45 GMT

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:

YoussefBelloum — Thu, 01 Mar 2018 09:47:33 GMT

Hi,

try this on your exp expression:

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

jaumecf23 — Thu, 01 Mar 2018 09:53:57 GMT

Hi,

Try this.

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

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