Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Urgent-Straight table fields in Qlikview

I am new to qlikview. I have a question regarding straight tables. i have multiple tables loaded. I would like to know if I use different fields from different tables in the straight table as dimensions and expression - will the combinations be correct in the straight table as I am using different fields from different tables. The data model in the back end is already joined using natural joins. So please let me know if it is fine to use different fields from different tables in straight table.

2 Replies
Anil_Babu_Samineni

If is is really natural joins and data model looks great as it is associate to each that means you will get in straight table. If not, You could manipulate in date model variations.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

provided that the associations ("natural joins") in the data model are correct (the tables are linked based on the correct key fields and not by accidentally matching fields) - if everything is correct in the data model, then it's fine to use fields from multiple data tables in a single Chart, such as a Straight Table.

cheers,

Oleg Troyansky

Upgrade your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense