Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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
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;
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.