Skip to main content

Qlik

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
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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: 
WilsonEvans
Contributor
Contributor
‎2020-12-12 03:10 AM

Extending Dimension to Second table?

I have two tables T1 and T2. I have joined them with Year month of Date D1 in T1 with Year month of Date D2 in T2. Now i need to build a chart to see the daily trends. My Dimension is Day(D1) and my expression is sum(Sales1 in T1)/sum(Sales2 in T2). But when i do this, the numerator is grouped by the Day(D1) whereas the denominator is not grouped by Day(D2). I want it to be Day(D1) = Day(D2) for calculating the daily metrics. Any idea on how to achieve this? 

Thanks!

https://9apps.ooo/
315 Views
0 Likes
1 Reply
Marcos_Ferreira_dos_Santos
Creator II
Creator II
‎2020-12-15 06:27 AM

Hi WilsonEvans,

Do your tables have data for all days in the period ? Maybe one could have Sales for day 12 and the other no... This would be a problem for Qlikview... 

BR,

 

 

 

259 Views
0 Likes