Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

wdchristensen
Valued Contributor

Recursive CTE - Equivalent in Qlik Sense

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

GO

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Recursive CTE - Equivalent in Qlik Sense

This might be interesting reading for you:

Hierarchies

View solution in original post

2 Replies
wdchristensen
Valued Contributor

Re: Recursive CTE - Equivalent in Qlik Sense

Bueller

Bueller

Bueller

Bueller... - YouTube

MVP
MVP

Re: Recursive CTE - Equivalent in Qlik Sense

This might be interesting reading for you:

Hierarchies

View solution in original post