# Qlik Sense App Development

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
MVP

## Re: If Count Expression

Would you be able to share a sample where we can see the issue?

Highlighted
MVP

## Re: If Count Expression

Also, you might be able to try this and see if this works

=Aggr(

If(count({1} [filename]) <= 10, Dual('0-10 Times', 0),

If(count({1} [filename]) > 10 and count({1} [filename]) <= 30, Dual('11-30 Times', 1),

If(count({1} [filename]) > 30 and count({1} [filename]) <= 50, Dual('31-50 Times', 2),

If(count({1} [filename]) > 50, Dual('50+ Times', 3)))))

, [filename])

or

=Aggr(

If(count({1<[filename] = p([filename])>} [filename]) <= 10, Dual('0-10 Times', 0),

If(count({1<[filename] = p([filename])>} [filename]) > 10 and count({1<[filename] = p([filename])>} [filename]) <= 30, Dual('11-30 Times', 1),

If(count({1<[filename] = p([filename])>} [filename]) > 30 and count({1<[filename] = p([filename])>} [filename]) <= 50, Dual('31-50 Times', 2),

If(count({1<[filename] = p([filename])>} [filename]) > 50, Dual('50+ Times', 3)))))

, [filename])

Highlighted
Partner

## Re: If Count Expression

Yes, the last one worked.

I made a mistake with the suggestion you gave me yesterday.  I forgot that I changed the field "filename" to "Filename" with an uppercase F.  So that was the problem yesterday.  It's possible that the solution you gave me yesterday worked but it was my oversight with the field name change.  I'm going to use the last one though since I just tried it and it works.

Thank you SO much!!