Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I got two tables:
Table1:
Who | where | count |
A | pl_1 | 4 |
A | pl_1 | 3 |
A | pl_2 | 8 |
B | pl_1 | 5 |
Table2:
who | where | frequency |
A | pl_1 | 10 |
A | pl_3 | 5 |
B | pl_1 | 20 |
the results should be a pivot table with:
|
If I use a left join between the table A and table B, my frequency will be wrongly a sum (ex a;Pl_1;20 instead of 10, caz in order to have the total frequency, I should use SUM(b.frequency)).
In both cases (left join and join) I got no A;Pl3.
I cannot understand:
1) what should be the ?function? used for the frequency (Expressions)
2)How could I join the two table to have the A;Pl_3 in the pivot (Scripting)
Saying "other expressions based on A" I 'd like you to understand the other expressions of the pivot table are quite complex and referring only to table A.
Can you help me?
See attached qvw.
thank you for your answer.
I understood the problem was different.
In my table1, I got a function like week(DATA) as week_grp, table2 joined with table1 also on DATA.
When I make a selection on week_grp the A;Pl_3 is kicked out.
Is there anything I can do in the join to avoid making week(DATA) also in table2?
it seems really weird to me, I thought functions like that would be considered just as attributes, and joining the table was enough to use them without replaying in the secondary table.