topic Diff b/w Count and RowNo? in QlikView

Diff b/w Count and RowNo?

sunilkumarqv — Thu, 06 Feb 2014 05:58:28 GMT

Hi ,

can any one tell diff b/w count and rowno .I have emp table used in straight table one dimension as ID and exp. as rowno(total),

total rows is showing 150 not matching the data in my database .if i use count(ID) its matching .Can anyone brief these to me please.

Re: Diff b/w Count and RowNo?

hic — Thu, 06 Feb 2014 06:33:59 GMT

These two functions are very different.

Count() is an aggregation function, i.e. it counts the number of records associated with a dimensional value. It can be used as expression in a chart or as function in the load script if you have a "Group By". It takes many records as input and returns one number as output.

RowNo() is a scalar function, and counts the number of records as output from a Load statement.

HIC

Re: Diff b/w Count and RowNo?

sunilkumarqv — Thu, 06 Feb 2014 06:53:58 GMT

thanks Henric . Can explore it with some examples ?

Re: Diff b/w Count and RowNo?

hic — Thu, 06 Feb 2014 07:08:14 GMT

I suggest you make your own example. For instance, if you use the following script:

Load

RowNo() as ID,

Pick(Ceil(3*Rand()),'A','B','C') as Dim

Autogenerate 100 ;

you will be able to see a lot. Create a pivot table with Dim as dimension and Count(ID) as expression. Further, add RowNo() as second expression. Now the difference should be obvious.

HIC

Re: Diff b/w Count and RowNo?

MK_QSL — Thu, 06 Feb 2014 07:08:47 GMT

Please check enclosed file...

Hope this helps.

Re: Diff b/w Count and RowNo?

sunilkumarqv — Thu, 06 Feb 2014 08:13:51 GMT

Thanks manish and Henric realy i learn't somthing new .