4 Replies Latest reply: Apr 20, 2016 6:01 PM by Stefan Wühl RSS

    How does Qlik know which table I want to evaluate in my chart expression

    Tor Kielland

      Probably a basic questions, but I need to figure this out to understand how Qlik works. Any help is appreciated!

       

      Consider the following two tables:

       

      Table A

      Col1
      1
      2
      3
      4

       

      Table B

      Col1
      1
      2
      5

       

      Since the two tables both have a column with the name 'Col1', the two tables will be joined in Qliks data model.

       

      Let's say I have a chart expression:

       

      Count(Col1)

       

      Questions:

       

      1) What will be the resulting value of the chart expression?

       

      2) How does Qlik decide which table to count?

       

      3) How can I qualify the table column name in the chart expression (e.g. by adding a table name) so that I'm in control of which table is counted?

       

      Thanks!