Problem with count of records

[#1]

Hi all,

I have a problem with rowno(), I have a connection with OLEDB, and I load a table with id, idValue and price, in a simple table I make the average of this prices, and all is correct, but my problem is that I need make the average of the last 200 records. I have seem that the function rowno(), to assign a autonumeric to each record, but when I use this function, It return the count of total table, and I need group by idValue.

Thanks in advance,

Irene.

[#2]

A lot of thanks,

But , when arrive in the script at this point:

JOIN TMP_TABLE (The firts "join").

To appear an error that say "TMP_TABLE", doesn't exist.

Irene.

[#3]

Hi,

Put the Function "NOCONCATENATE" after TMP_TABLE:

Ex.:

TMP_TABLE:

NOCONCATENATE

LOAD

  IDMERCADO,

  CODIGOMERCADO

....

[#4]

All is correct in the script, but when arrive at join with AUX_COTIZACIONES_VALOR, the qlickView is blocked...load the data correctly, and after doesn't make nothing... I don't nkow if the qlickview have a limit data... the table cotizaciones_valor have 2.000.000 records...

[#5]

Hi,

The qlikview always return all table for me.

I worked with tables more then 10.000.000 records and never blocked any register.

Maybe the joins between table are not correct. I don't know how is your model.

Do you can create a sql consult for me?

Ex.:

SELECT *

FROM VALORES, VALOR_INDICE, MERCADO...

WHERE ...

I can to try convert sql to qlikview language.

[#6]

Yes of course , this the model.

[#7]

And in the sql file you can see the query 🙂

[#8]

A lot of thanks for your help,

Now, it's work correctly , only I have one doubt now, if I want do the average of 200 records before, I can write this sentence:

Avg( If (numrow >= min(numrow) + 200, cierre))

Thanks in advance Irene.