Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: How to count number of rows ?

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))

17 Replies
MVP
MVP

Re: How to count number of rows ?

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
Honored Contributor

Re: How to count number of rows ?

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

Not applicable

Re: How to count number of rows ?

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.

MVP
MVP

Re: How to count number of rows ?

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

Not applicable

Re: How to count number of rows ?

I am still looking for the solution.

Thanks

MVP
MVP

Re: How to count number of rows ?

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

Re: How to count number of rows ?

Qlik Image.PNG

Highlighted
Not applicable

Re: How to count number of rows ?

Please let me know if you are not able to understand

MVP
MVP

Re: How to count number of rows ?

May be like this:

Count(DISTINCT Country&city)