Macro Manipulation Straight Table (Sort, Width, Delete)

Mon, 24 Dec 2012 10:55:16 GMT

Hello,

I am trying to build a Straight Tables via a macro, given that depending on the user selection, a different table needs to be loaded each time, at the same location.

One of the issues is that given that situation, I would like to delete the past table, before creating a new table with same Object ID (the same ID is required for fuctionality of the document).

Based on the GetObject statement I tried "ActiveDocument.RemoveSheetObject("Table")".

What is the correct syntax to delete a sheet object ?

Also there is one column where I need to sort via a custom order.

Hence I used:

Table.GetProperties.Dimensions.Item(0).SortCriteria.SortByExpression = 1

Table.GetProperties.Dimensions.Item(0).SortCriteria.Expression.v = "=Match([Current State] , 'Submitted'" , 'Analysis Started')"

What is the correct way to phrase this ?

Lastly if possible, I would like to auto-width the columns, similar to manually selecting "Fit Columns To Data"

Is this possible, or do I need to set the column width manually to a fixed value ?

Thank you for your help

Re: Macro Manipulation Straight Table (Sort, Width, Delete)

Mon, 24 Dec 2012 11:06:24 GMT

plz. see the link.

hope it will help you..

http://community.qlik.com/thread/58846

http://community.qlik.com/thread/10900

thanks

topic Macro Manipulation Straight Table (Sort, Width, Delete) in QlikView

Macro Manipulation Straight Table (Sort, Width, Delete)

Re: Macro Manipulation Straight Table (Sort, Width, Delete)