topic Re: NoOfRows(TOTAL) outside n column expression in QlikView

NoOfRows(TOTAL) outside n column expression

Clever_Anjos — Thu, 31 Oct 2013 15:55:08 GMT

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.

Re: NoOfRows(TOTAL) outside n column expression

swuehl — Thu, 31 Oct 2013 16:28:21 GMT

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.

Re: NoOfRows(TOTAL) outside n column expression

Clever_Anjos — Thu, 31 Oct 2013 16:30:49 GMT

Thank you swuehl,

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

Re: NoOfRows(TOTAL) outside n column expression

Gysbert_Wassenaar — Thu, 31 Oct 2013 17:17:02 GMT

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

Re: NoOfRows(TOTAL) outside n column expression

swuehl — Thu, 31 Oct 2013 17:32:14 GMT

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?)

Re: NoOfRows(TOTAL) outside n column expression

Clever_Anjos — Thu, 31 Oct 2013 17:41:15 GMT

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.