2 Replies Latest reply: Mar 15, 2018 1:51 PM by Harinder Chahal RSS

    Relational tables

    Harinder Chahal


      I am new to Qlik Sense - would appreciate any help or resources on this:

      I have seven relational tables (tbl1, tabl2, etc), all linked on a specific files (fieldX). There are one-to-many (or one-to-none) relationships between the tables. How do I write a COUNT expression that counts the number of records in a given table on "filedX" (to create a measure that can then be used in visualizations)?


        • Re: Relational tables
          youssef belloum



          you can create your measures on the back-end (script) or on the front-end (charts).


          if you need to count the number of records:


          on the back-end, you will need to use Count(Field) with a Group by statement.


          on the front-end, you will need to use Count(Field) on a chart with the dimension you want.


          it would be interesting if you can attach some data here and the expected output via screen shots.

            • Re: Relational tables
              Harinder Chahal

              Hi Youseef -

              First - I accidentally created two posts for this, so there's another parallel discussion going on this.

              Second - this is literally my first couple of hours of using Qlik Sense - so not even sure how to access or edit the back-end scripts. Are you talking about scripting in the "Data load editor" section?

              Can you share any resources on editing scripts in Sense?