Discussion Board for collaboration related to QlikView App Development.
I have a real basic QV App whereby I have a dimension table of Stock control, like below:
|1||101||01-01-2018 01:00||02-01-2018 01:00|
|2||101||01-02-2018 06:55||20-02-2018 05:00|
|3||102||02-01-2018 00:00||03-01-2018 00:00|
|4||103||13-03-2018 06:00||15-03-2018 07:00|
|5||101||02-02-2018 23:00||28-02-2018 23:00|
Then a Fact table:
I then have a MasterCal based on DateIn.
What I expect using this expression is to get an average dwell per month =Aggr(Avg([Dwell]),[MonthYear])
With my expected results being:
What I am getting however is the same result per month:
Can someone point me in the right direction?!
I guess the problem is that you don't have your master calendar connected to your fact table
Since MonthYear is not connected to the main table....Avg([Dwell in Location]) is same across MonthYear... In the file that you provided what is DateIn and what is DateOut? Is t_put - DateIn and Next Location Put - DateOut?
Also, what if DateIn and and DateOut span multiple months? Is that something which can happen?
Are you using Interval Match with your DateIn and DateOut table?
Why do you even need Aggr here if [Month year ] is the only dimension
Sorry, yes I am. It is then joined back into the SC table.
Sorry Pradosh, You are correct in that i don't need it, i still get the same answer. I think as Sunny eluded to, this could be because I am using interval match.
What are you interval matching on from your second table's point of view? In other words, which field does DateIn and DateOut matched to?
stalwar1 how did you know he is using interval match ?
How else can you join two dates in a single table to one date in another table
I created a bridge whereby I created a Key using key & datein.
Just a note: I'm not slow to reply, my comments need to be moderated first!