Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with count of records

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.

16 Replies
Not applicable
Author

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.

Not applicable
Author

Hi,

Put the Function "NOCONCATENATE" after TMP_TABLE:

Ex.:

TMP_TABLE:

NOCONCATENATE

LOAD

  IDMERCADO,

  CODIGOMERCADO

....

Not applicable
Author

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...

Not applicable
Author

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.

Not applicable
Author

Yes of course , this the model.

Not applicable
Author

And in the sql file you can see the query 🙂

Not applicable
Author

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.