0 Replies Latest reply: Apr 18, 2013 12:12 PM by Gustavo Grossmann RSS

    Trying to organize tables in a sheet

      Hi,

       

      I'm relative new in Qlikview, and one of the sheets that i'm working, have 3 tables.

      The second one, have variable data: depending the numbers of days in filter, that table have more ou less data.

       

      Well, i'm trying to organize the tables, to always have them organize. The third table, 50 pixels under the second, and the second, 50 pixels under the first.

      With fixed data, is easy. In the proprieties of the tables, i can do that.

      With macro too, using the function positionbox.

       

      But with variable data, I can't do it.

       

      I've seeing the community, and i have to calculate the "visible area" of a table, and calculate the position of the tables with positionbox in macro. But, I don't found a way to find this "visible area".

       

      In my last try, i've calculate the number of lines in table, using "=count(Distinct(test))", and set this to a variable.

       

      But how can I use this variable in macro?

       

      I've tried in macro:

           set VaribleInMacro = ActiveDocumento.Variables ("variable")

      And:

           set VaribleInMacro = ActiveDocumento.Variables ("variable").GetContent.int

      And:

           set VaribleInMacro = variable

      And:

           set VaribleInMacro = $variable

       

      And no one worked.

       

      Any solutions?