Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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):
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):
Add a text box with the expression
=sum($Rows)
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.