Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

petersvendsen
New Contributor II

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

Re: Can tasks be sorted in different table lists?

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
petersvendsen
New Contributor II

Re: Can tasks be sorted in different table lists?

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
Valued Contributor II

Re: Can tasks be sorted in different table lists?

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

petersvendsen
New Contributor II

Re: Can tasks be sorted in different table lists?

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

Re: Can tasks be sorted in different table lists?

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
Valued Contributor II

Re: Can tasks be sorted in different table lists?

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'}.

petersvendsen
New Contributor II

Re: Can tasks be sorted in different table lists?

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

petersvendsen
New Contributor II

Re: Can tasks be sorted in different table lists?

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

petersvendsen
New Contributor II

Re: Can tasks be sorted in different table lists?

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

Community Browser