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.
Solved! Go to Solution.
Perhaps something like sum(aggr(1, Dim1, Dim2, ... , DimN)) where Dim1, Dim2 etc are the dimensions you use in your straight table.
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))