Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

I am doing a Direct Query, but get error in chart when analyzing data

When I try to put my data in a table, this error comes up. I don't understand since I created the same report without Direct Query and works fine. I am trying to use the Direct Queries to see how they work

Screen Shot 2017-09-13 at 10.40.18 AM.png

The query goes like:

     DIRECT QUERY
          dimension

               memberId,

               date,

               other fields

         from tableA, tableB, tableC, factTable

         where tableA.id = factTable.id

          and tableB.clientId = factTable.clientId

          and tableC.otherId = factTable.otherId

Thank you,

Andres