NoOfRows(TOTAL) outside n column expression

[Clever_Anjos]

If I use NoOfRows(TOTAL) into a column expression of a straight graph, it returns how many rows my table has.

Is there any way to use it outside a column expression? When I use it into a caption or other place it always returns 1

I would like to use it inside a calculation condition preventing my table to has too many rows avoiding performance issues.

[swuehl]

I don't think that you can make use of this function in gobal context, e.g. in a calculation condition.

There are several threads here that discuss this behaviour and some suggests some workaround, e.g. using a macro

(like in today's post)

For what you want to do, it would be sufficient to know a rough estimate, so you could try counting the dimension values involved or something like that.

[Clever_Anjos]

Thank you swuehl,

" counting the dimension values" that´s what I´m doing today, I was trying to use a more generic way

[Gysbert_Wassenaar]

Like Stefan says an estimate will do for the calculation expression. Especially if you don't have a pivot table with lots of partial sum totals. I usually use count(aggr(1, Dim1, Dim2, ... , DimN))

[swuehl]

I was trying to use a more generic way

Yes, would be neat if QV would offer a possibility to read some other objects properties, like the number of rows, using QV functions in chart expressions.

But especially for the calculation condition, I think it would be quite tricky to get this information before QV actually performs the calculation (is this a hen / egg issue?)

[Clever_Anjos]

swuehl, I don´t know the exact order the calculations are made so maybe is there any way of preventing some memory leaks.

It would be nicer if there´s some property like "Maximum Rows, please don´t go beyond XXXX rows"

Some of my clients and students insists into creating really big tables consuming lots of Gigabytes of Server RAM and sometimes is hard to explain to them that a table with 10mi rows is useless.

Thank you swuehl and Wassenaar, I´m a big fan of you 2.