Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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
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?
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;
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'}.
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
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
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!!