Discussion board where members can get started with Qlik Sense.
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:
LOAD "DW_EK_Date" as "DW_SK_Date",
"Month_Key" as "YearMonthNum",
"Month_Char" as Month,
Left("DW_EK_Date",6) as YearMonth
FROM "excel file"
(ooxml, embedded labels, table is Calendar);
(ooxml, embedded labels, table is Org);
(ooxml, embedded labels, table is Fct);