Adding fields to Table box control dynamically

[#1]

Hello ,

I'm new to QlikView and need a help to add columns dynamically to Table Box Control. 

Below is the dataset : I need to show member and their participation sport. Say, Member M1 is participating in swimming and Skating and M2 in skating and Diving.

Member	Swimming	Skating	Diving
M1	1	1	0
M2	0	1	1
M3	0	0	1

I have created stored procedure in sql server and calling in QV report. I am using a Table Box control to show above columns .

I need to accomplish the task that if a user add a new sport (say, Fencing) , a new column automatically gets added to QV report.

I am able to get the updated data set with new sport

Member	Swimming	Skating	Diving	Fencing
M1	1	1	0	0
M2	0	1	1	0
M3	0	0	1	0

Could any one help me on this?

Thanks in advance!! will appreciate it

[swuehl]

Try to convert your table from a crosstable to a straight table using the CROSSTABLE LOAD prefix when loading your data:

The Crosstable Load

This will transform your sport categories into a single field which you can use as dimension in a pivot table, thus automatically adding new values (sport categories) when available.