Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
toedegaard
New Contributor III

Missing link between ParentChild and Calendar

Hi,

I am having trouble with my parent child hierarachy at it does not react as I expecting when I am choosing a month.

For example if I choose Year Month = 201703, it should only show me the amount in my fact table for records within my parent child hierarchy, that are valid in that month.

So in the example attached it should only show me the record where LevelName2 = CD, however the fields DW_ValidFrom_Organisation and DW_ValidTo_Organisation does not show the right figures.

My script in Qlik Sense is:

Calendar:

LOAD "DW_EK_Date" as "DW_SK_Date",

  "Year",

    "Year_StartDate",

    "Year_EndDate",

    Quarter,

    "Quarter_Key",

    "Month_Key" as "YearMonthNum",

    "Month_Char" as Month,

    "Month_Name_EN",

    "Month_StartDate",

    "Month_EndDate",

    Left("DW_EK_Date",6) as YearMonth

FROM "excel file"

(ooxml, embedded labels, table is Calendar);

Organisation:

Hierarchy(DW_EK_Organisation, DW_EK_OrganisationParent,LevelName)

LOAD

    DW_SK_Organisation,

    DW_EK_Organisation,

    LoadDate_Organisation,

    LevelID,

    LevelName,

    LevelType,

    DW_EK_OrganisationParent,

    OrganisationLevel,

    Date(DW_ValidFrom_Organisation,'YYYY-MM-DD hh:mm:ss'),

    Date(DW_ValidTo_Organisation,'YYYY-MM-DD hh:mm:ss'),

    NewestOrganisation,

    MaxLoadDate_Organisation,

    DeletedOrganisation

FROM "excel file"

(ooxml, embedded labels, table is Org);

Fact:

LOAD

    DW_SK_Organisation,

    DW_SK_Account,

    DW_SK_IncomeStatementsFTE,

    DW_SK_Date,

    LoadDate_IncomeStatements,

    TransactionDate,

    "Type",

    Amount,

    AdjustmentComment,

    MaxLoadDate_IncomeStatements

FROM "excel file"

(ooxml, embedded labels, table is Fct);

Best regards,

Thomas