Count using condition in Qlik Sense

[Shahzad_Ahsan]

Hi Everyone

I have table like this

Item	Flag
A	1
B	0
C	1
D	1

How to count on basis of flag??

I want measure expression that counts only flag=1  i.e. 3

[surendraj · Accepted solution]

count({<flag={1}>}flag)

[Shahzad_Ahsan]

Thanks Surendra

{<flag={1}>}

this what I was looking for

[Anonymous]

Maybe try Set Analysis

     sum( { < [ Flag] = {1} > } [Flag] )

[Typed freehand, hope no typo's]

[Shahzad_Ahsan]

How we can give not equal???

[surendraj]

count({<flag-={1}>}flag) // BY -=