Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

thnkgreen
Not applicable

Once and For All - RECORD COUNT

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

Capture2.PNG.png

I just want a dynamic record counter   Thanks everybody

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Once and For All - RECORD COUNT

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

comm107057.png


talk is cheap, supply exceeds demand
3 Replies
Gysbert_Wassenaar
Not applicable

Re: Once and For All - RECORD COUNT

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

comm107057.png


talk is cheap, supply exceeds demand
colin_albert
Not applicable

Re: Once and For All - RECORD COUNT

Add a text box with the expression

=sum($Rows)

thnkgreen
Not applicable

Re: Once and For All - RECORD COUNT

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.