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: 
rsmithy
Contributor III
Contributor III

Qualifying on multiple tables (Edited)

What am I doing incorrectly, I am "double qualifying" my fields.   -->   table1.table2.Item   Example below:

rsmithy_0-1644435360306.png

I can see that the issue is caused by WIDGET_SUMMARY.  If I remove that then i don't qualify on "TRACKER"

 

 

 

1 Solution

Accepted Solutions
rsmithy
Contributor III
Contributor III
Author

I need unqualify *

View solution in original post

3 Replies
Digvijay_Singh

I tested with this script and it looks fine to me

TRACKER:
LOAD * INLINE [
ITEM, ITEM_ID, ITEM_DATE
TVm 10001, 01/01/2022
];

STORE TRACKER INTO 'lib://testdata/test.qvd' (qvd);
;
DROP TABLE TRACKER;

WIDGETS:
Qualify *;
LOAD *
FROM 'lib://testdata/test.qvd' (qvd);

Unqualify;

Digvijay_Singh_0-1644435360206.png

But I see your problem mentioned in one of the community post by @datanibbler 

https://community.qlik.com/t5/QlikView-App-Dev/qualify-and-unqualify/td-p/262056

Thanks,

 

rsmithy
Contributor III
Contributor III
Author

I need unqualify *

rsmithy
Contributor III
Contributor III
Author

Thanks,  I edited the post to include the qualify statement prior to what I had posted., which was where the issue was.