Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count of city in text object

Hi All,

i need to get count of city which is having less than 4 headcount in a text box.

Example

city , Headcount

A, 10

B, 20

C, 2

D, 1

F,  3

In textbox i need 3 , because city c, d f headcount is less than 4

Thanks in advance

1 Solution

Accepted Solutions
Kushal_Chawda

In case if you have more details in your data

Count({<city={"=sum(Headcount)<4"}>} city)

View solution in original post

6 Replies
antoniotiman
Master III
Master III

=Count({<Headcount={"<4"}>} city)

its_anandrjs
Champion III
Champion III

Try with

=Count({<Headcount={'<4'}>} city)

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Shan,

Try below one:

=Count({<Headcount={'<4'}>} Distinct city)

Thanks,

Arvind Patil



Anonymous
Not applicable
Author

Hi Shan,

Expression for your Output:

=Count({<Headcount -= {">4"}>}City)

Regards,

Rajan

Kushal_Chawda

In case if you have more details in your data

Count({<city={"=sum(Headcount)<4"}>} city)

Anonymous
Not applicable
Author

Hi kushal,

Thanks worked perfectly