Adding fields to Table box control dynamically

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Adding fields to Table box control dynamically

swuehl — Mon, 08 Aug 2016 21:46:38 GMT

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.

topic Re: Adding fields to Table box control dynamically in QlikView

Adding fields to Table box control dynamically

Re: Adding fields to Table box control dynamically