topic Re: How to create QVD from following SQL join Statement in QlikView

How to create QVD from following SQL join Statement

vikasmahajan — Fri, 17 Oct 2014 09:18:30 GMT

Hii,

Experts Can any one tell me how to create qvd from following SQL Statement

Select Doc_Num,Doc_Type,Item_Ledger_Entry_No,B.Quantity

FROM FACT_QV_ValueEntry A

INNER JOIN FACT QV_ProductionOrder B

ON A.Doc_Num = B.No_

WHERE A.Entry_Type = 6 AND A.[Item Ledger Entry Quantity] <> 0 AND A.[Expected Quantity] = 0

AND Item_Ledger_Entry_No IN

(SELECT MIN(Item_Ledger_Entry_No) FROM FACT_QV_ValueEntry A

INNER JOIN FACT_QV_ProductionOrder B

ON A.Doc_Num = B.No_

WHERE A.Entry_Type = 6 AND A.[Item Ledger Entry Quantity] <> 0 AND A.[Expected Quantity] = 0

GROUP BY Doc_Num)

Thanks

Vikas

sivarajs — Fri, 17 Oct 2014 09:26:21 GMT

This is single table now. You can create,

Table:

your sql

store Table into Table.qvd (qvd);

Is this your expected output?

vikasmahajan — Fri, 17 Oct 2014 10:39:15 GMT

I want to create qvd from sql sub query see this clause

Item_Ledger_Entry_No IN ( ...)

do you have any idea how to perform this for creation of qvd ?

Vikas