Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count number of rows ?

I have created a Straight table which has multiple rows of data?

I want to count the number of rows and shown it in another KPI ?

Please help me do it in Qliksense .

Thanks,

Nitesh

1 Solution

Accepted Solutions
sunny_talwar

May be use one of the expression from your table or use your first dimension if you have not used set analysis in your expression.

May be like this

Count(DISTINCT Dimension1)

or

Count(Aggr(YourExpression, YourDimensions))

View solution in original post

18 Replies
sunny_talwar

May be use one of the expression from your table or use your first dimension if you have not used set analysis in your expression.

May be like this

Count(DISTINCT Dimension1)

or

Count(Aggr(YourExpression, YourDimensions))

rittermd
Master
Master

Can you use the RowNo() function in your KPI?

Not applicable
Author

Thanks Mark and Sunny.

Let me explain you my situation .

The table which I have created has close to 70 fields.

I have a primary key and due to other dimensions it is getting duplicated in the table and that is acceptable.

I am not sure how many times each if gets duplicated so when I export the excel the number of rows vary each time .

I want to show the number of rows in a KPI in the sheet. So that before exporting they should know the number of rows they can expect in the excel.

sunny_talwar

You marked my response as correct, is the issue really resolved are you still looking for help here?

Not applicable
Author

I am still looking for the solution.

Thanks

sunny_talwar

Would you be able to provide a sample of your application so that we can see what you have and help you in getting what you want

Not applicable
Author

Qlik Image.PNG

Not applicable
Author

Please let me know if you are not able to understand

sunny_talwar

May be like this:

Count(DISTINCT Country&city)