Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
colonel-tushfinger
Contributor II
Contributor II
‎2019-01-25 02:38 PM

Can Qlik utilize SQL's hierarchyID datatype?

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?

Labels (2)
Labels
752 Views
4 Replies
JustinDallas
Specialist III
Specialist III
‎2019-01-25 03:49 PM

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.

731 Views
0 Likes
colonel-tushfinger
Contributor II
Contributor II
‎2019-01-25 07:47 PM
Author

In response to JustinDallas

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.

716 Views
0 Likes
colonel-tushfinger
Contributor II
Contributor II
‎2019-01-29 04:50 PM
Author

In response to JustinDallas

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.

674 Views
0 Likes