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:


      2Cat2Bbnot match
      3Cat1Aanot match
      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?