Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Joins

Hi.  I wanted to know if there was a way I could just quickly hit some kind of button or something to clear all the joins that Qlikview created?  I am working with tables that have the same names for fields but they are not supposed to be joined; the data is different.  Instead of correcting each join is there a quick way to eliminate all the joins and then establish them myself?  Thank you.

4 Replies
er_mohit
Honored Contributor II

Re: Joins

using Ctrl + F

Not applicable

Re: Joins

Ctrl + F is just a find and replace

Re: Joins

Hi,

Qlikview has feature to join the fields with same name. You won't stop that which is the speciality of Qlikview.

What you need to do is rename the fields which should not join.

MVP & Luminary
MVP & Luminary

Re: Joins

The join will happen automatically when the field name is the same. You can't change that behavior. You can rename the fields so they don't link up.

A quick way to do this is the QUALIFY script statement.

QUALIFY *;

That will preprend the table name to each field name giving you unique field names for each table. You follow the above QUALIFY with an UNQUALIFY to name the fields that you do want to link.

For example:

QUALIFY *;

UNQUALIFY CustomerID, ProductIID;

Orders:

SQL SELECT * FROM Orders;

Customers:

SQL SELECT * FROM Customers;

Products:

SQL SELECT * FROM Products;

-Rob