count record in application

[#1]

How to calculate no. of records added on daily basis .

by writing code at front end. i dnt want to count no.of records by adding code at backend

[ashfaq_haseeb]

Hi,

To show yesterday count try something like this

=count({<Date={"$(=today()-1)"}>}Field)

Replace it with your required fields.

Regards

ASHFAQ

[datanibbler]

Hi Shweta,

on the frontend, you could create a variable that is first used to check the current nr. of records against it (just count some unique record-identifier like a row_Nr or so) and then updated with the current nr. of records (to be checked the next day).

Since variables are among the first things which are by default calculated on the frontend, that will be a bit tricky, however - you'd have to somehow prevent the variable being updated with the current count at once, which would render impossible the task of comparing against it the current nr_of_records.

In the script, it would be much easier, you could just store the nr_of_records on a given day in a qvd, load it on the next day (together with a datestamp that should be in the qvd) and then compare.

[avinashelite]

Hi Shweta,

To achieve this you should have a Date field using which you can calculate the no of records, based on the yesterday day count and today's day count. Otherwise in the front end its not possible.

In the back end you take the snap shot of the records on daily basis by appending the everyday's date with it.

Regards,

@vi

[#5]

Hi,

use following function

NoOfRows(['TableName ' ])

[#6]

It won't work

[schlettig]

Hi,

you could try to add a field for instance: 1 as record_count,

Then you can later on simply use sum(record_count).

That's quite fast and gives you the No of records.

BR,

Christian

[#8]

i can't understand.Could you elaborate a bit more

[#9]

i have 6 table.can't we calculated total records a once

[schlettig]

for each table you want to count records in you add another line in the QlikView Script:

1 as record_count_table1

So when the script is executed you have the value 1 in every line.

With this you can then sum up as you like.

I hope this ansers your question, otherwise you'll need to be more specific on what you want to see where and how's you data model structured.

If you need this for data governance reason and maybe for all your qvw files, you could also take a look a the

http://community.qlik.com/community/discussion-forums/qlikview-governance-dashboard

BR,

Christian