Can tasks be sorted in different table lists?

[Anonymous]

Hi all,

I have an idea that I would like to have 2 table liste 1 that shows the tasks for kids and 1 table list for the adults.

Imagine we have a table like this

Type	Activity	Location	Bring
Kids	Run	Stadium
Adults	Prepare food	Kitchen	Food
Adults	Clean up	Common area	Cleaning material
Kids	Sleep	Individual room

Now I would like QlikView to have 2 table lists 1 where ONLY kids activities are listed, the outcome would be something like this

Type	Activity	Location
Kids	Run	Stadium
Kids	Sleep	Individual room

While it would look like this for adults

Type	Activity	Location	Bring
Adults	Prepare food	Kitchen	Food
Adults	Clean up	Common area	Cleaning material

So it should be the Type that should decide if it should be listed on the Kids table list or the adult table form....

Is that possible?

[Gysbert_Wassenaar]

Sure, it's possible. But do you really need two charts. If you have one chart and a listbox for the Type field then you can easily use that one table to show Kids or Adults or both. Just select the types you want to see in the listbox.

If you do want two tables then it's probably easiest to create one or two alternate states (on the General tab of the Document Properties window) and assign the alternate state(s) to the relevant table. You can then select the type in the table. Selections in one alternate state won't have effect on objects in another state.

[Anonymous]

It is because I want the table list to be different from the 2 types.

This is ofcause a simple example, in reality the 2 types are very different and therefore I would like to have the lists to be seperate.

[Gabriel]

Hi,

What gwassenaar suggested is right.

What you can also do is to create the 2 charts then use Set Analysis to restrict each chart to show either Adult or Kids, i.e. where Type = {'Kids'} or where Type = {'Adult'}.

Hope this helps

[Anonymous]

Sounds right, but where can I set the analysis?

I looked in the table list and can not see the analysis...... could I get a hint?

[#6]

Peter, You can split your source table into no of small table like you want. But the only probelm is you may end up with synthetic keys or circular loops if you ahve other dimension tables keep only one table. It better keep into one table and create the flags on your table to differentiate the  data granularity type.

You can try like below for your case:

SourceTemp:

LOAD

     Type , Activity , Location, Bring

From SourceTable;

Qualify * ; // to avoid syn keys

Kids:

LOAD

     Type , Activity , Location

Resident SourceTemp where Type ='Kids';

Adults:

LOAD

     Type , Activity , Location , Bring

Resident SourceTemp where Type ='Adults';

Drop Table SourceTemp;

[Gabriel]

Hi,

In the Expression tab, you must be doing some sort of aggregation, i.e. COUNT,SUM e.t.c. in there just include Set Analysis for each chart where Type = {'Kids'} or where Type = {'Adult'}.

[Anonymous]

Hi Gabriel,

Where do I set the "Set analysis" for the charts?

I'm still new to QlikView 😕 I'm not able to locate it.

Thanks

Peter

[Anonymous]

Hi Dathu,

Thanks for the suggestion.

So is it correct that this would load the data and afterwards sort it into either Adult or Kids.. and then skip the original data load but keep the newly sorted?

BR,

Peter

[Anonymous]

Hi again,

It seems that when I follow this approach I get the same entry many times as hits, so when I list it in tablelist I get the same entry several times repeated!!

If I look in the xls the entry is only there once!!