4 Replies Latest reply: Jul 25, 2017 5:27 AM by Naveen Uppala RSS

    Match Rate in Bar chart

    Naveen Uppala

      Hello Experts,

       

      I am new to Qlik world!

      Trying to create a bar chart where it will show match rate (%) for each of categories.

       

      Sample Data:

        

                  IDCategorySourcedestStatus
      1Cat1AAMatch
      2Cat2Bbnot match
      3Cat1Aanot match
      4Cat1CCCCMatch
      5Cat3dDnot match

       

      Source and dest fields are coming from two different databases(both are Postgres in this case)

      I tried to create chart by adding 'Category' as Dimension where each Category and its match rate is represented as bar.

      I tried to create below measure but it doesn't show any results.

       

      count({$ <Source= dest>}[Category])/count([Category])

       

      Any suggestions?

       

      Thanks,

      Naveen