topic Re: SQL Query in QlikView

SQL Query

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

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..

Re: SQL Query

Anil_Babu_Samineni — Tue, 05 Dec 2017 12:35:48 GMT

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

Re: SQL Query

Clever_Anjos — Tue, 05 Dec 2017 12:49:49 GMT

Maybe

SELECT

Code1,

sum(Quantity)

from XYZ

INNER JOIN ABC on ABC.TransID = XYZ.TransID

group by Code1

Re: SQL Query

prashantsanchet — Tue, 05 Dec 2017 13:49:48 GMT

SELECT

Code1,

sum(Quantity)

from XYZ

INNER JOIN ABC on ABC.TransID = XYZ.TransID

group by Code1

Re: SQL Query

its_anandrjs — Tue, 05 Dec 2017 14:03:30 GMT

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,