topic Re: rowno rank in QlikView

rowno rank

Thu, 24 Jul 2014 07:35:22 GMT

Hi community,

I have the expression rank(total rowno(total)) to get the number of rows in a chart.

But I have an issue with the performance of the expression because the data is too big.

Is there any alternative that can improve the performance and offers the same result?

Regards,

Re: rowno rank

MK_QSL — Thu, 24 Jul 2014 08:00:18 GMT

use the same in Script end... What actually you are looking for using this expression?

Re: rowno rank

Thu, 24 Jul 2014 08:18:07 GMT

I dont want to add it in the script as I want it to dynamicaly calculate for every chart I use it.

I an using it to count the numbr of rows in the chart.

Any other ideas on how to better utilise the expression inside the chart?

Re: rowno rank

tresB — Thu, 24 Jul 2014 08:23:39 GMT

RowNo(total) alone?

Re: rowno rank

MK_QSL — Thu, 24 Jul 2014 08:23:48 GMT

The best is you already using... may be wait for some other Gurus to reply...

Rank(Total RowNo(TOTAL))

Re: rowno rank

Thu, 24 Jul 2014 08:27:09 GMT

RowNo(total) alone does not give the correct results inside the chart.

Is there any other way to take the max number of number of rows in a chart by using a different expression?

Re: rowno rank

tresB — Thu, 24 Jul 2014 08:31:43 GMT

NoOfRows(total) ?

Re: rowno rank

Thu, 24 Jul 2014 08:45:38 GMT

Hi tresesco thanks for the quick reply

This could be the correct answer. But I have not yet tested the performance of NoOfRows(total).

Out of your experiance which one do you think it performs best?

Re: rowno rank

tresB — Thu, 24 Jul 2014 08:53:35 GMT

I have not tested with big data. Still, from general comprehension can say - it should be the one with single function (i.e - NoOfRows(total) ), because in the other one, qv has to operate on two functions -one on onother's output, which would be more costly in terms of performance.