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

    Help with expression please

    Richard Judkins



      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!