Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Pivot table on disjoined field

Hi everybody,

I got two tables:

Table1:

Whowherecount
Apl_14
Apl_13
Apl_28
Bpl_15

Table2:

whowherefrequency
Apl_110
Apl_35
Bpl_120

the results should be a pivot table with:

whowheresum(count)?Function?(FREQUENCY)other expressions based on A
Apl_1710
Apl_280
Apl_305
total A 1515
Bpl_1520
total B 520

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?

2 Replies

Re: Pivot table on disjoined field

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Pivot table on disjoined field

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.

Community Browser