Recursive CTE - Equivalent in Qlik Sense

wdchristensen — Tue, 09 May 2017 14:40:51 GMT

How can the recursive tsql code below be written in qlik?

https://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/

USE AdventureWorks
GO
WITH Emp_CTE AS (
SELECT EmployeeID, ContactID, LoginID, ManagerID, Title, BirthDate
FROM HumanResources.Employee
WHERE ManagerID IS NULL
UNION ALL
SELECT e.EmployeeID, e.ContactID, e.LoginID, e.ManagerID, e.Title, e.BirthDate
FROM HumanResources.Employee e
INNER JOIN Emp_CTE ecte ON ecte.EmployeeID = e.ManagerID
)
SELECT *
FROM Emp_CTE

Re: Recursive CTE - Equivalent in Qlik Sense

wdchristensen — Fri, 05 Jan 2018 22:22:33 GMT

Bueller

Bueller... - YouTube

Re: Recursive CTE - Equivalent in Qlik Sense

petter — Fri, 05 Jan 2018 23:00:04 GMT

This might be interesting reading for you:

Hierarchies

topic Recursive CTE - Equivalent in Qlik Sense in QlikView

Recursive CTE - Equivalent in Qlik Sense

Re: Recursive CTE - Equivalent in Qlik Sense

Re: Recursive CTE - Equivalent in Qlik Sense