Inputfields will not work within the Aggr() function. They will not work as dimensions even if you don't use the Aggr(), note how the ID in the attached application is an inputfield and how the straight table does not aggregate by ID, but it does when you change the script to make to rows have the same ID. QlikView "knows" somehow that the value is not it's not the source value, and although it displays the new entered value, does not aggregate it, as you can see in the file.
The idea on inputfields as far as I'm concerned is not about dimensions, rather than expressions, meaning that they are inteded to store numeric values that can change and may affect to some aggregations that in turn must use their own functions, like InputSum() or InputAvg().
By the way, I'm using version 11, and I have not tested it in previous versions, but I guess they behave likewise.
Hope that makes sense.
qcomInputFieldAggr.qvw 157.0 K
The inputfield does work as a dimension in the table on the right if you change the dimension from 'ID' to =Text(ID). In other words, inputfields treat every value in them as unique, even if they are identical in content. But when you use the 'Text' function, it groups like values together in the input field so that it behaves like any other normal field. Therefore, it can be used as a dimension with this slight workaround. I'm wanting to know if there is some way to perform aggregation on this Text(inputfield) value either using aggr() or set analyis or some other method.
qcomInputFieldAggr.qvw 156.0 K
This is a longshot but did you ever find a solution to this problem?
I have exactly the same issue and am pretty stuck.
I need to use the Aggr Function in order to retrieve the Top X.
My data looks like the below
The text field is the input so I would want to use the Aggr to perform a group by sum, i.e. a total for 'Misc-Other','Industrial - SE' etc etc