Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
paul_scotchford
Valued Contributor

Concatenate Month grained fact to Day grained fact

Hi All

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

Store.

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 ?

Many thanks

Paul

Tags (3)
2 Replies

Re: Concatenate Month grained fact to Day grained fact

This is possible and you can read about one way to do it on Fact Table with Mixed Granularity:

HIC

paul_scotchford
Valued Contributor

Re: Concatenate Month grained fact to Day grained fact

Thanks Henric, this is very useful.