topic Re: Urgent-Straight table fields in Qlikview in QlikView

Urgent-Straight table fields in Qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Urgent-Straight table fields in Qlikview

Anil_Babu_Samineni — Sat, 28 Oct 2017 11:30:08 GMT

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.

Re: Urgent-Straight table fields in Qlikview

Oleg_Troyansky — Sat, 28 Oct 2017 17:00:19 GMT

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