topic Re: Extending Dimension to Second table in QlikView

Extending Dimension to Second table

balajiqlikuser — Wed, 02 Dec 2020 09:46:07 GMT

Hi all,

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!

Re: Extending Dimension to Second table

edwin — Wed, 02 Dec 2020 20:57:21 GMT

not knowing the columns, peripheral dimensions of both tables, or the data model in general, i would say find a way to concatenate these two tables and have just one date and 2 measures. or can you link them together by renaming one of the dates so they are the same. it sounds like they are linked by date anyway. otherwise create a link table if there are more than just one field that relates them

Re: Extending Dimension to Second table

Kushal_Chawda — Wed, 02 Dec 2020 22:40:15 GMT

@balajiqlikuser Why don't you just join them based on Date in T1 & Date in T2 instead of year month?