Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, Can you give a hand on this. I'm not experiences with SCDs. I have materials with a load that can change over time (increase, decrease or stay the same) as you can see on the first table with a first period until sept 14th and the latter beginning on the 15th sept.
In my KPI and in the next table the values ares aggregated with a sum() because we want to aggregate the load of more than one material in the end.
Customer should be able to select september but doing so, QlikSense aggregates the load of each period (because both period exists in september). It sums duplicates every time it encounters two periods in one selection. What is the most performant solution in order to avoid that given that firstsortedvalue and aggr() make the app performance terrible.
