Help with expression please

[Anonymous]

Hi

I have this expression in a filter pane for a table in Qlik Sense Server:

= Aggr( If (Count({<[Client ID]=>} Product)=1,'1 Module','More than 1 Module'),[Client ID])

What I'm wanting to do is to add another condition - if the count < 1 then 'No Modules'.

So, in a nutshell:

<1: 'No Modules'

=1: '1 Module'

All else: 'More than 1 Module'

I can't work out how to incorporate that additional condition though - any assistance greatly appreciated thanks!

[PrashantSangle · Accepted solution]

why are you using aggr()? any specific reason..

use nested if, try below expression

Aggr(If (Count({<[Client ID]=>} Product)<1,'No Modules',If (Count({<[Client ID]=>} Product)=1,'1 Module','More than 1 Module')),[Client ID])

Regards,

[Anonymous]

It was an expression I found in a forum here, and just modified it for my use - so I have no idea really, sorry!

But thank you - your suggestion works perfectly.

[PrashantSangle]

if aggr() not required, then remove it. It consume unnecessary RAM.

below

If (Count({<[Client ID]=>} Product)<1,'No Modules',If (Count({<[Client ID]=>} Product)=1,'1 Module','More than 1 Module'))

Regards,