Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-02-17 02:57 AM

Handling Multiple Dates in a Single Report

Hi Guys,

I am having 4 Fact Tables and 4 different dates coming from the same. The developed report consists of Measures dependent on different Fact Tables. whenever I Select a Date from the respective Fact table, only the data associated to it shows correct values.

I need a single date which would be associated with all the Fact tables.

Kindly help me to resolve the issue.

Thanks & Regards

Sumeet

3,422 Views
0 Likes
10 Replies
Not applicable
‎2015-02-20 05:46 AM
Author

In response to tobias_klett

Hi Tobias,

I created a Link Table from the 4 Fact. Associated the Link table with all the Facts with a Single Link Key.

Also created another Key in the Link table which would be associated to the Dimension and Concatenated all the Date fields into a single column.

It worked and the Values are matching as well.

Regards

Sumeet Vaidya

281 Views
0 Likes