Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Re: If Count Expression

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

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
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!!