Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Not applicable

How to get count and Sum of freq in Text boxs

Hi All,

I have to calculate the count of country names having frequency >=3 and sum of frequency .I am attaching sample data as shown in sheet 1. i did manual calculation in sheet 2.

Could you please help me in solving the prob .

Thanks,

Rahul

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: How to get count and Sum of freq in Text boxs

Use Below in TEXT BOX at UI end

=SUM(IF(AGGR(COUNT([Country Name]),[Country Name])>=3,1,0))

and

=SUM(IF(AGGR(COUNT([Country Name]),[Country Name])>=3,Aggr(COUNT([Country Name]),[Country Name]),0))

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: How to get count and Sum of freq in Text boxs

Use Below in TEXT BOX at UI end

=SUM(IF(AGGR(COUNT([Country Name]),[Country Name])>=3,1,0))

and

=SUM(IF(AGGR(COUNT([Country Name]),[Country Name])>=3,Aggr(COUNT([Country Name]),[Country Name]),0))

View solution in original post

Highlighted
Not applicable

Re: How to get count and Sum of freq in Text boxs

Thanks Manish