topic Collapse Table box by default in QlikView

Collapse Table box by default

Fri, 10 May 2013 23:47:34 GMT

Hi,

I'm using a table box to display the hours of day (12 AM, 1 AM, ...), I want to display just one row by default, however when the document loads all table is displayed, after selecting one value it collapses as expected. I changed the Table box Height property to 10 inside Caption tab , but now when I click on the Table box it doesn't expand any more, it just displays a scroll bar. Any idea will be appreciated.

Thanks

Re: Collapse Table box by default

Gysbert_Wassenaar — Sat, 11 May 2013 07:23:38 GMT

If you set a height then that's the maximum height. If you set the heigth to a value higher than is needed to display the possible values (determined by the selections) then the table box will shrink to the needed height. If you want only one row displayed by default then you have to have one value selected by default. You could use an Select in Field action assigned to the OnOpen document trigger for that so a value is selected when you open the document.

Re: Collapse Table box by default

Wed, 15 May 2013 14:00:40 GMT

Thanks Gysbert!

I dis what you suggest using the trigger and it's working as expected. However, when using the plug-in to display the document if I select 'Refresh' to reload the document the table boxes expand again, is there some other trigger I should use after refresh? I looked for some event but couldn't find

Re: Collapse Table box by default

Gysbert_Wassenaar — Wed, 15 May 2013 14:32:56 GMT

There's also an OnPostReload trigger. You could try adding the same kind of action to that trigger too.