Discussion Board for collaboration on QlikView Scripting.
I have a problem with organization hierarchy.
Organization table is joined to link table with interval match (this link is working OK)
main problem is that in d_organization table I have multiple rows with same ID
How can I create Hierarchy with hierarchy()-funktion so that it's working properly with slowly changing dimensios?
At the moment Name 1 and Name 2 are both always active
Did you select a date? Otherwise, how should Qlikview know which organisation records should be shown?
Yes, I have selected a date
Can you post a qlikview document that demonstrates the problem? Read this document if you're worried about confidential information: Preparing examples for Upload - Reduction and Data Scrambling