

Creator III
2017-11-28
03:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count using condition in Qlik Sense
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
21,383 Views
1 Solution
Accepted Solutions


Specialist
2017-11-28
03:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
count({<flag={1}>}flag)
5 Replies


Specialist
2017-11-28
03:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
count({<flag={1}>}flag)


Creator III
2017-11-28
03:35 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Surendra
{<flag={1}>}
this what I was looking for

Anonymous
Not applicable
2017-11-28
03:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe try Set Analysis
sum( { < [ Flag] = {1} > } [Flag] )
[Typed freehand, hope no typo's]


Creator III
2017-11-28
03:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How we can give not equal???
20,748 Views


Specialist
2017-11-28
03:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
count({<flag-={1}>}flag) // BY -=
