topic Re: Association of columns between two tables in QlikView

Association of columns between two tables

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

In short: I have A and B column in table1, B and C column in table2. Tables are associated through B.

Data is loaded from Excel.

Table 1: Issuance of Invoice.

Brand

InvoiceNum

TypeOfOperation (issue)

SumOfOperation

Table 2: Payment of Invoice

InvoiceNum

TypeOfOperation (payment)

SumOfOperation

Two tables are associated by common columns InvoiceNum, TypeOfOperation, SumOfOperation

For those Invoices which match between two tables, I want Table2 to take “Brand” from Table1 and show it in the PIVOT.

I am trying to create a PIVOT table:

ROW = Brand

COLUMN = TypeOfOperation

MEASURE = SumOfOperation (sum)

However, it shows (null) in the Brand ROW against payments, although in the Data Model I can clearly see the association. Why?

Re: Association of columns between two tables

marcus_sommer — Thu, 09 Feb 2017 14:35:43 GMT

With your approach you creates synthetic keys and maybe also circular loops and this should be avoided. I suggest to concatenate both tables. More informations about this will you find here: Get started with developing qlik datamodels.

- Marcus

Re: Association of columns between two tables

vangurideepu — Thu, 09 Feb 2017 14:47:58 GMT

Hi Gleb,

This problem seems getting synthentic keys and circular loops...

for your approach you can make join or concatenation of both tables..

Thanks a lot

vangurideepu