Problem with rowno() and average

Wed, 06 Jul 2011 17:56:06 GMT

Hi all,

I have a problem to calculate the average with a rowno(), I have the following table:

id Key Value NumRow=rowno()

12 1 45 1

14 1 46 2

78 1 78 3

83 2 45 4

98 2 67 5

98 2 98 7

I have a simple table with grouping by key, in this table if I select the key 2, and I write the following expression, NumSum(min(rownum),1), the result is 5 , and is correct, but I need do the average for a determinate quantity of records for example, the average for records 4 and 5 only (always grouping by key).

I write this expression:

Avg(if(NumRow<=NumSum(min(numRow),2),value)) --> Error in expresion

NumAvg(If(NumRow<=NumSum(min(numRow),2),value)) --> Expresion is OK, but not appear nothing in the table.

topic Problem with rowno() and average in QlikView

Problem with rowno() and average