sql to qlik script

shravanveer — Fri, 15 Nov 2024 22:08:34 GMT

hi can anyone convert these script into qlikview script

Select * from Category C left join Products P ON
C.[Category ID]=P.Category left join OrderDetails OD ON
P.ProductID=OD.ProductID
Where P.ProductID between 12 and 29
Order by P.ProductID

Re: sql to qlik script

sidhiq91 — Sun, 26 Jun 2022 08:15:47 GMT

We can write the above query in Qlik as below. Please mark it as solved if it has resolved your issue.

NoConcatenate
Category:
Load *, [Category ID]
from Category;

left join(Category)
Load *,Category as [Category ID],
ProductID
From Products
where ProductID>12 and ProductID<29;

Left join (Category)
Load *,ProductID
From OrderDetails

topic sql to qlik script in QlikView

sql to qlik script

Re: sql to qlik script