Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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
MVP & Luminary
MVP & Luminary

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.