Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Hierarchy and Slowly Changing Dimensions

Hi,

I have a problem with organization hierarchy.

Organization table is joined to link table with interval match (this link is working OK)

problem.png

main problem is that in d_organization table I have multiple rows with same ID

Organization_id
Namescd_start_datescd_end_date
1001Name 101.01.201210.12.2012
1001Name 111.12.201231.12.2014
1001Name 201.01.201531.12.9999

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

cheers,

Tommi

Tags (1)
3 Replies

Re: Hierarchy and Slowly Changing Dimensions

Did you select a date? Otherwise, how should Qlikview know which organisation records should be shown?


talk is cheap, supply exceeds demand
Not applicable

Re: Hierarchy and Slowly Changing Dimensions

Yes, I have selected a date

Re: Hierarchy and Slowly Changing Dimensions

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


talk is cheap, supply exceeds demand
Community Browser