topic Table box hide base on another table box in QlikView

Table box hide base on another table box

ivandrago — Tue, 24 Aug 2010 22:52:30 GMT

Hi,

I have 6 different charts on one tab, 2 of them are a table box which i use for detail. When I double click on one of them the current chart will minimize and the new one will appearing in the same location. For the two table box I want them to be excluded from the other 4 graphs, so when I double click on one them I want it to appear on a different location on the page but I do not want the graph to hide, the graph should only hide when the other 4 are clicked.

Thanks

Table box hide base on another table box

vgutkovsky — Tue, 24 Aug 2010 23:19:52 GMT

Ivan,

This is a very popular request, but is not possible with QV 8 or 9. You can only have 1 autominimize group per sheet. I think QV 10 allows multiple groups so you can define which objects should be group together for minimization. For now, you will need to design around this limitation.

Regards,

Table box hide base on another table box

ivandrago — Tue, 24 Aug 2010 23:29:47 GMT

Do you think a macro would work so it would hide and unhide the table? If so would you know what the code would be for this?

Thanks

Table box hide base on another table box

vgutkovsky — Tue, 24 Aug 2010 23:37:30 GMT

Sure, you can do this with a macro and then set a button to execute the macro. Check the API guide for more details, but I think the API you want is ActiveDocument.GetSheetObject("ID").Minimize

Regards,

Table box hide base on another table box

ivandrago — Thu, 26 Aug 2010 21:34:30 GMT

Would you be able to provide a example qvw that does this?

Table box hide base on another table box

vgutkovsky — Thu, 26 Aug 2010 22:22:24 GMT

There are different ways of doing this, but 1 example is attached.

Regards,

Table box hide base on another table box

ivandrago — Mon, 30 Aug 2010 22:02:43 GMT

Thanks! Nice work!