# Qlik Sense App Development MVP

## Re: If Count Expression

Would you be able to share a sample where we can see the issue? 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]) 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!!