Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can tasks be sorted in different table lists?

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

TypeActivityLocationBring
KidsRunStadium
AdultsPrepare foodKitchenFood
AdultsClean upCommon areaCleaning material
KidsSleepIndividual 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

TypeActivityLocation
KidsRunStadium
KidsSleepIndividual room

While it would look like this for adults

TypeActivityLocationBring
AdultsPrepare foodKitchenFood
AdultsClean upCommon areaCleaning 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?

9 Replies
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.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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
Not applicable
Author

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?

Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

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!!