Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

quriouss
Contributor III

Why is my simple table data showing multple rows (orthogonal join)?

Update: My fault completely - I had a LOOSEN() statement in the load script - I thought this acted at the table-level (disconnected each table) but having re-read the documentation it acts at the FIELD level (removes the associations between each field).

I removed the LOOSEN() and re-wrote the script using NoConcatenate() and it seems to be working.  Thanks, all.

I have a large-ish table of clients (2.3 million records) which are coming from Oracle.

In the Data Model Viewer the data seems correct. One table, with 2.3 million rows, with one row per client.

However, if I put that data into a table in Qlik Sense, I get what looks like an orthogonal join on my data, so I get repeated rows (and then the app runs out of resources.

See here for an example; New York is mapped to every country in the world.

ManyCities.png

However, if I add a measure (any measure, in this case it's just an integer, the number '1') the repeated rows disappear.

ManyCities2.png

So, two questions;

1.  Why is it happening (is it a scripting issue)? and

2.  How can I stop it happening?

Tags (2)
15 Replies

Re: Why is my simple table data showing multple rows (orthogonal join)?

Are these two fields in two different tables not connected on a unique identifier? Can you share a screenshot of your data model or your script?

quriouss
Contributor III

Re: Why is my simple table data showing multple rows (orthogonal join)?

No, just one simple table with 2.2 million rows (exactly as many as I would expect).

SingleTable.png

And for what it's worth, here is the client key;

Data_Model.png

Re: Why is my simple table data showing multple rows (orthogonal join)?

What dimensions and measures have you used on your table?

Employee
Employee

Re: Why is my simple table data showing multple rows (orthogonal join)?

Would you mind sharing the SQL that retrieves your data?

quriouss
Contributor III

Re: Why is my simple table data showing multple rows (orthogonal join)?

Well, it's this;

LOAD

*

FROM [lib://Qlik Data Files (qvd)/Get_Client_Details.qvd] (qvd);

Re: Why is my simple table data showing multple rows (orthogonal join)?

Have you checked if the number of rows has increased on decreased? Meaning check if the number of rows in your database are the same or have they ballooned?

gompa786
Contributor III

Re: Why is my simple table data showing multple rows (orthogonal join)?

Since it is being read from an already loaded QVD that should not behave in the way you are experiencing ...

is this load statement in any Loop (For loop) or is it just a singleton load query in the app?

or are you Extracting data from the database and loading the QVD and again accessing the same QVD in the same app?

Thanks

Employee
Employee

Re: Why is my simple table data showing multple rows (orthogonal join)?

I meant the SQL query, could you post it?

quriouss
Contributor III

Re: Why is my simple table data showing multple rows (orthogonal join)?

The number of rows in the database is the same as the number of rows in Qlik.

Community Browser