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