topic Re: Can Qlik utilize SQL's hierarchyID datatype? in App Development

Can Qlik utilize SQL's hierarchyID datatype?

colonel-tushfinger — Sat, 16 Nov 2024 21:31:57 GMT

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?

Re: Can Qlik utilize SQL's hierarchyID datatype?

JustinDallas — Fri, 25 Jan 2019 20:49:22 GMT

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.

Re: Can Qlik utilize SQL's hierarchyID datatype?

colonel-tushfinger — Sat, 26 Jan 2019 00:57:12 GMT

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.

Re: Can Qlik utilize SQL's hierarchyID datatype?

JustinDallas — Mon, 28 Jan 2019 16:21:38 GMT

Have you looked at this?

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/Hierarchy.htm

Re: Can Qlik utilize SQL's hierarchyID datatype?

colonel-tushfinger — Tue, 29 Jan 2019 21:50:16 GMT

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.