Discussion Board for collaboration on QlikView Layout & Visualizations.
I am looking for an effective way to apply Month grained fact Data to Day grained data ?
Scenario is ...
Month based Sales Budgets to concatenate into a
Day based Sales fact
One obvious answer is to make Daily budget facts and concatenate to the Sales Fact, but this
will misrepresent the shape of the chart as budgets are determined for a Stock Sub Category and
Currently I concatenate at a Month level and this is fine in a chart where rolling at Month to Year ,
but when drilling to the Week, Day then of course the budget value will be 0.
Has anyone done something like this ?
This is possible and you can read about one way to do it on Fact Table with Mixed Granularity:
Thanks Henric, this is very useful.