Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
Put the Function "NOCONCATENATE" after TMP_TABLE:
Ex.:
TMP_TABLE:
NOCONCATENATE
LOAD
IDMERCADO,
CODIGOMERCADO
....
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...
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.
Yes of course , this the model.
And in the sql file you can see the query 🙂
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.