3 Replies Latest reply: Aug 16, 2018 1:17 AM by Prashant Sangle RSS

    Help with expression please

    Richard Judkins

      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!