SQL Query

[nareshthavidishetty]

We are hvaing two tables

Fact:

sales,

Code1,

TransID

from XYZ;

Dim:

TransID,

Quantity

from ABC;

Qlikview logic: sum(Quantity) where dimension = Code1

Please provide the SQL query to check in SQL DB for UT.

Thanks..

[Anil_Babu_Samineni]

I don't see any Logic in Qlikview here, What are you trying and what you want to use in SQL? Please provide full picture

[Clever_Anjos · Accepted solution]

Maybe

SELECT

     Code1,

sum(Quantity)

from XYZ

INNER JOIN ABC on ABC.TransID = XYZ.TransID

group by Code1

[prashantsanchet]

SELECT

     Code1,

sum(Quantity)

from XYZ

INNER JOIN ABC on ABC.TransID = XYZ.TransID

group by Code1

[its_anandrjs]

In Qlik you can try this

Fact:

sales,

Code1,

TransID

from XYZ;

Inner Join(Fact)

Dim:

TransID,

Quantity

from ABC;

Noconcatenate

NewChk:

Load

Code1,TransID,

Sum(Quantity) as QtySum

Resident Fact

Group By Code1,TransID;

Drop table Fact,