Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a project where we need to be able to provide a hierarchy of objects. In SQL Server we're utilizing the hierarchyId datatype and it works perfectly though there are functions that are proprietary to SQL server to use it fully.
Can the hierarchyID datatype be interpreted by Qlik? It appears there is some amount of painful conversion that "might" need to occur to go down this path but I'm trying to identify what is possible and how?
What do you want to do with HiearchyId? It's a SQL Server data type so you should just be able to read it and work with it however you want.
SQL isn't the problem. This hierarchical data is going be applied on reporting in Qlik. I've got a conflict of opinions here so I'm looking for product specific information.
That does explain Qlik hierarchy well but not the connection to SQL's hierarchyId datatype. The two aren't exactly 1:1 so it seems some sort of bridge would have to be built.