Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
Gabriel
Partner - Specialist III
Partner - Specialist III

count(Field1)

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

View solution in original post

8 Replies
maleksafa
Specialist
Specialist

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

Gabriel
Partner - Specialist III
Partner - Specialist III

count(Field1)

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

Gysbert_Wassenaar

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
awhitfield
Partner - Champion
Partner - Champion

Hi there,

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

Andy

Anonymous
Not applicable
Author

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!

awhitfield
Partner - Champion
Partner - Champion

There's a few different options in the attached file

Andy

Not applicable
Author

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
Author

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