Discussion Board for collaboration on QlikView Scripting.
Colleagues, what function in load script can calculate number of row, aggregated by some list of field?
For example, i have table and in load script i need ti calculate file Position, aggregated by Agent and Day - All values of Points must have values from 1 to Quantity of Points in Agent-Day Range
Create a straight table with Agent, Day & Point as dimension and add RowNo() as expression. This will give you expected results.
Thanks. But all pre-calculations i must implement in load script, because final result must be saved into qvd file also in LS.
AutoNumber(Recno(), Agent&Day) as Position
(ooxml, embedded labels, table is Лист1);
if you just want to add the row number you can add the function in the script:
Please note the difference between using RecNo() and RowNo() which won't give same results --> rowno() and recno()
I 100% agree with Stefan! You can implement the approach suggested by him.
Another method using Previous function
If(Agent = Previous(Agent) and Day = Previous(Day), RangeSum(Peek('Position'), 1), 1) as Position
Order By Agent, Day;
DROP Table Table;