I wonder if anyone has found a good way in which to carry out hierarchy calculations at the highest level in the hierarchy of items appearing in a grid? What I would like to be able to do is to sum together the values of a given field for items which are not hierarchical children, but are instead top level items TLI.

 

The specific application is that I have a field called Effort. I would like to be able to sum together the various values of Effort so that I know what my overall Backlog is.

 

There is already a Visual Basic function available in InfoQube:

Return of a previous issue:

 

1) Clicking on item hyperlink opens it in scratch grid instead of its home grid

 

2) Side-problem #1: tried to check on homegrid assignment in properties pane but field ItemHomeGrid is missing.

(IDItem field is also missing).

 

3) Instead, I added ItemHomeGrid to forms.  As expected, the field was blank so I entered the correct grid.

 

4) Tried hyperlink again.  Still opens in scratch grid instead of home grid.  Created hyperlink a second time but got same result.

 

Side-problem #2: is there a way to search the properties pane?  I frequently have trouble finding fields, especially system fields.

 

Side-problem #3:  My forms list is still repeatedly closing when it shouldn't. 

 

Side-problem #4: In properties pane, if I try to switch betwee

the problem is that whenever I manually type a '#' symbol in column filters it does not work

 

=>

Using the column filter, I'm trying to find a tag-word e.g.

#layout,

 

the following do not work when typed in i.e. nothing at all is displayed in the filtered grid

If a grid uses the field "finances" as the source, and the user changes the field name to "financial", the grid should maintain the source.  I often fiddle with grid names and field names as I'm adding more and more grids/fields to IQ, and it's always time consuming to have to reset grid sources when all I wanted to do was rename a field.

 

Thanks

Just getting to try out history now -- wasn't sure where to post about it so started this thread.

 

Here's your screenshot Pierre

 

 

[edit// corrected image]

In one of my grid, I have a text Field, using SQL  "SELECT" from another grid.

I successfully achieved it.

 

When I add an new item, move the cursor to that Field, I found out that I need to double click the field, then I can see a drop-down list arrow on the right side of the field, then you click it to choose the field value you need; and you can not just type and IQ will automatically match the value to automatically select it for you like some other MS software do.

 

Here is my question, how can I achieve to do this : 

 

- move cursor to that Field by typing 'Tab', or just using cursor arrow to move.

- then just type the letter of the field value you expect to "SELECT" from other grid by SQL.

- then IQ will show any matching value from the other grid's item been "SELECT"ed.

 

B.regards

Sean