topic Re: Count number of Rows in QlikView

Count number of Rows

Fri, 27 Mar 2015 14:36:33 GMT

Hi All,

I am newbie in qlikview. I want to calculate number of rows. I uploaded my 4 csv files through Table files. I am unable to calculate actual number of rows in straight table chart.

Re: Count number of Rows

maleksafa — Fri, 27 Mar 2015 14:39:48 GMT

add a simple expression= count(Field), if you want unique values then count(DISTINCT Field)

Re: Count number of Rows

Gabriel — Fri, 27 Mar 2015 14:42:08 GMT

count(Field1)

Field1 would be the field that identify each row (Unique ID)

Re: Count number of Rows

Gysbert_Wassenaar — Fri, 27 Mar 2015 14:55:59 GMT

Perhaps something like sum(aggr(1, Dim1, Dim2, ... , DimN)) where Dim1, Dim2 etc are the dimensions you use in your straight table.

Re: Count number of Rows

awhitfield — Fri, 27 Mar 2015 15:15:04 GMT

Hi there,

where do you want to see the number of rows displayed?

Andy

Re: Count number of Rows

Anonymous — Fri, 27 Mar 2015 15:30:42 GMT

In the straight table properties under expression tab add a new expression

count(csv file field name)

to get only unique values count(DISTINCT(csv file field name))

Thanks!

Re: Count number of Rows

awhitfield — Fri, 27 Mar 2015 15:33:26 GMT

There's a few different options in the attached file

Andy

Re: Count number of Rows

Fri, 27 Mar 2015 16:10:44 GMT

Thanks for quick reply, problem solved. All replies are very useful for me. Once again thank you very much all of you !. You all are the masters of Qlikview

Re: Count number of Rows

Tue, 09 Jun 2015 12:47:18 GMT

Oke thanks! But when I would sort on value, is that possible?