Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
urbanfaces
Contributor III
Contributor III

Dont want section data to be linked to each other

I have sections in my data load script.

Currently, I have two sections, and they are pulling data from entirely different tables. However, they appeared to be linked. When I go to the pivot, it pulls data based on a selection of the other sections.

How can I have each data pulled from their respective sections?

Also, it is slowing the application.

Labels (2)
3 Replies
MatheusC
Specialist II
Specialist II

@urbanfaces 

See with the Qualify statement

Qualify *;

https://community.qlik.com/t5/Member-Articles/Do-you-Qualify-How-to-use-QUALIFY-statement/ta-p/14850...

Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
BrunPierre
Partner - Master II
Partner - Master II

Hi, by using the Qualify statement within the load script to prepend each field name with its corresponding table name.

Qualify *;
T1:
Load
FieldA,
FieldB
From Table1;

marcus_sommer

Like already mentioned you prevent it with a qualifying. But having several independent data-models within a single application is not really sensible. Usually it caused more trouble as it solves. Better would be you divide it into two applications.