(In my log file it is not showing growing chains of single quotes) you can see when you compare between your log file and mine that one difference between our environments is the processing of quote characters, they seems to incur additional wrapping on your end. 'perception' has scared off or discouraged. However I'm going to follow with a post that illustrates the disconnect from documentation and functionality, god only knows how many would-be adopters of QlikView this divergence of 'reality' vs. Toss it out!Īttached is a newer and more brief version, that does the same thing as before, but the entire chain assembly happens in the hierarchy function.

It cites no functional code examples that illustrate its fully intended formĪll that looping of code that was happening in the prior version of the apps in this thread, where its trying to create a chain of concatenation of the hierarchy tiers and add a delimiter? That is basically trying to emulate what the hierarchy function would be doing if the later parameter arguments were applied, but with a lot more code, complexity, and convolution.

To exacerbate the problem, the documentation of the hierarchy function in the manual has 3 issues: If you don't use the EXACT CORRECT arguments for hierarchy, the true capabilities of the function remain concealed. Everything is clear now and all that needs to be done is engage the later parameters of this function, however. I've had inconsistent results in the past where that whole process of trying to loop through the values and chain them together and detect the depth, it wasn't necessary. I'm glad we worked on this because I've had this nagging feeling there is something about the hierarchy function that is off, but just couldn't put my finger on it.

Download mdac version 6.1.7600.16385