Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Count number of Rows

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.

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Count number of Rows

count(Field1)

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

View solution in original post

8 Replies
maleksafa
Valued Contributor

Re: Count number of Rows

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

Partner
Partner

Re: Count number of Rows

count(Field1)

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

View solution in original post

MVP & Luminary
MVP & Luminary

Re: Count number of Rows

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


talk is cheap, supply exceeds demand
Partner
Partner

Re: Count number of Rows

Hi there,

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

Andy

chinnukool
New Contributor III

Re: Count number of Rows

Hi


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!

Partner
Partner

Re: Count number of Rows

There's a few different options in the attached file

Andy

Not applicable

Re: Count number of Rows

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

Not applicable

Re: Count number of Rows

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