topic Two Transaction Table in QlikView

Two Transaction Table

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

Suppose I have mainly two transacion table.Then how to make Data Model for it.How to apply logic for it.Wheather I have to concatenate both tables and make flag for Field or any other logic ??

Please can any one help me I am little bit confused in it....

Re: Two Transaction Table

ziadm — Mon, 01 May 2017 15:00:34 GMT

If both table having same or close structure then its best to concatenate both tables. if you need to differentiate transaction from the table then you add a new field as a flag of the table

FactTable:

Load

ProdID,

Sales,

SaleDate,

'Region1' as TransactionSource

From RegionSales1.QVD

Concatenate

Load

ProdID,

Sales,

SaleDate,

'Region2' as TransactionSource

From RegionSales2.QVD

Then you may use Set Analysis in your application to sum only sales from Region1 as

Sum({<TransactionSource = {Region1}>}Sales

or

Sum({<TransactionSource = {Region2}>}Sales