2 Replies Latest reply: May 20, 2015 5:19 AM by satish qlik RSS

    Charts with count of Distinct Records

      Hi Friends ,

       

      I have a requirement

        

      CountryLIST TYPEMAR
      AEBICBMCADR1
      AECILBMCADR1
      AEBICBMCADR3
      AECILBMCADR4
      AUBICBMCADR5
      AUCILBMCADR6
      AUAUMBMCADR6
      INDAUMBMCADR8
      INDBICBMCADR9
      INDBIC

      BMCADR10

      In the Above data , i have to build a chart based on the Country code as Dimension and Count (List Type) as Expression

       

      Condition : I should Consider the List Type with only DISTINCT MAR (Out of 10 MAR , only 8 are distinct)

       

      Regards,

      Senthil