2 Replies Latest reply: Dec 11, 2016 10:54 PM by jagan mohan rao appala RSS

    Showing a constant value for a measure in all rows

    Rajarshi Guin

      Hi,

       

      I have a report in Qlik Sense as below

      MarketFirms TragettedMeasure 2Measure 3
      Market 110011
      Market 215022

       

      The Market column is a Dimension while others are measures. The Firms Tragetted value is calculated as-

      Count(Distinct [Firms Targetted])

       

      My concern is the Firms Targetted measure needs to be the distinct count from all the records in the database irrespective of the Market and the value will be constant for all the rows.

       

      I tried few options like-

      Count({1}Distinct [Firms Targetted])

      Count({<[MARKET]=>}Distinct [Firms Targetted])

      Count({<[MARKET]={}>}Distinct [Firms Targetted])

      Count({<[MARKET]={''}>}Distinct [Firms Targetted])

       

      But none of these are working. Can anyone please suggest how to do this.

       

      Thanks,

      Rajarshi