topic Re: Once and For All - RECORD COUNT in QlikView

Once and For All - RECORD COUNT

Anonymous — Tue, 11 Feb 2014 17:01:22 GMT

Hello fellow QlikView friends. I have searched many different places on the internet and still have not found an answer that clearly lays out the answer to this question. In Access, there is a handy little box at the bottom of each table that provides the total number of records. I want to create something that will perform the same function in QV. Maybe in a later version of QlikView this will be added as a feature??

I just want a dynamic record counter Thanks everybody

Re: Once and For All - RECORD COUNT

Gysbert_Wassenaar — Tue, 11 Feb 2014 17:15:05 GMT

In Qlikview you can find this in the lower right corner of the main window. In the image below you can see that the selected object has 9 records in 2 columns (see the 9 x 2 to the right of the date/time):

Re: Once and For All - RECORD COUNT

Colin-Albert — Tue, 11 Feb 2014 17:15:15 GMT

Add a text box with the expression

=sum($Rows)

Re: Once and For All - RECORD COUNT

Anonymous — Tue, 11 Feb 2014 17:20:00 GMT

Gysbert, I had never noticed that information on the bottom of the screen. Thanks so much for pointing it out. Also, another way that I found handy (though a bit more involved) is by doing the following:

1. Create a straight table chart using data from a table

2. Under Expressions, type Count(Distinct field1 & field2 & field3....etc)

This will show you the row total as well.