Section Access : avoid reduction on specified fields

alexprost — Fri, 15 Nov 2013 17:16:13 GMT

Hi,

Here is a simple example with script to illustrate my problem:

PEOPLE:

LOAD * INLINE [

    NAME, CITY

    Jean, Paris

    Pierre, Paris

    John, London

];

TRAVEL:

LOAD * INLINE [

    NAME, CONTINENT

    Jean, Europe

    Jean, Africa

    Jean, Oceania

    Pierre, Asia

    Pierre, Europe

    Pierre, America

    John, Europe

    John, America

    John, Oceania

];

Two tables :

- people living in cities

- continent where those people travelled

The 2 guys leaving in Paris has travelled in each 5 continents.

The only guy leaving in London travelled only in 3 continents.

If I apply a section access on people leaving in London, the selection list object for field CONTINENT will be reduced to 3 items.

Logical for Qlikview, but I want to display the whole list of 5 continents. Because I want to display that John has never visited Asia for Example.

I hope my example is clear enough, because I'm currently facing a similar problem.

Thanks for your help,

Alexandre

topic Section Access : avoid reduction on specified fields in QlikView

Section Access : avoid reduction on specified fields