Count number of Rows

[#1]

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.

[maleksafa]

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

[Gabriel · Accepted solution]

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.

[awhitfield]

Hi there,

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

Andy

[Anonymous]

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]

There's a few different options in the attached file

Andy

[#8]

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

[#9]

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