what is primary key and foreign key - Qlik Community

ramesh1234 · ‎2017-12-26

what is primary key and foreign key give me example i am new to learn qlikview please help me

kaushiknsolanki · ‎2017-12-26

Hi,

This are the normal SQL concepts. You can do a quick google search and learn about it. Below is one of the link.

Primary and Foreign Key Constraints | Microsoft Docs

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

antonaks · ‎2017-12-26

Hi!

Primary key is a Unique key in your table, as example ID of goods in SKU dictionary.

Foreign key is a ID of goods in fact table with sales, as example, where primary key may be a transaction key.

These terms are more often used in an SQL environment. In QlikView, all the links are built on associations.

pradosh_thakur · ‎2017-12-26

Hi

There is no concept of primary-foreign key relation in QLIK. For SQL u can check out

SQL PRIMARY KEY Constraint

https://www.w3schools.com/sql/sql_foreignkey.asp

regards

Pradosh

Learning never stops.

Anonymous · ‎2017-12-26

Primary Key is a unique identifier in a table. For example:

In a table containing records of all employees (Employee ID, name, Dob, Designation), the "employee id"(being unique to each employee) to will be the primary key.

If another table is added which contains salaries for each designation ( Designation, Salary), the tables will be linked through designation column, thus making it the foreign key.

ramesh1234 · ‎2017-12-26

but interview purpose they asked questions

Peter_Cammaert · ‎2017-12-26

Those questions serve a purpose: the interviewer tries to get an idea of the breadth of your knowledge. If you only know something about the insides and workings of QlikView, you won't be able to figure out how to connect to an RDBMS (most common data source) and grab the necessary data for building a specific document, for example a Sales Order overview.

Compare this to the same interviewer asking questions about Excel. Maybe the company where you are solliciting for a job is a heavy user of Microsoft Excel. You won't learn how to become an Excel expert here in the Qlik Community, because there are probably a 1000 on-line sources that are better suited to teach you how to use Excel.

BTW Google is a better search engine anyway, even for looking up stuff in the QlikView community. If you're not sure about a new concept, always start your investigations there.

pradosh_thakur · ‎2017-12-26

please close the thread.

Regards

Pradosh

Learning never stops.

ramesh1234 · ‎2017-12-27

thanks