Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

Count using condition in Qlik Sense

Hi Everyone

I have table like this

ItemFlag
A1
B0
C1
D1

How to count on basis of flag??

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

1 Solution

Accepted Solutions
surendraj
Valued Contributor

Re: Count using condition in Qlik Sense

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

5 Replies
surendraj
Valued Contributor

Re: Count using condition in Qlik Sense

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

Shahzad_Ahsan
Contributor II

Re: Count using condition in Qlik Sense

Thanks Surendra

{<flag={1}>}


this what I was looking for

Re: Count using condition in Qlik Sense

Maybe try Set Analysis

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

[Typed freehand, hope no typo's]

Shahzad_Ahsan
Contributor II

Re: Count using condition in Qlik Sense

How we can give not equal???

surendraj
Valued Contributor

Re: Count using condition in Qlik Sense

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

Community Browser