topic Re: count record in application in QlikView

count record in application

Thu, 28 Aug 2014 09:40:10 GMT

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

Re: count record in application

ashfaq_haseeb — Thu, 28 Aug 2014 09:44:04 GMT

Hi,

To show yesterday count try something like this

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

Replace it with your required fields.

Regards

ASHFAQ

Re: count record in application

datanibbler — Thu, 28 Aug 2014 09:46:17 GMT

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.

Re: count record in application

avinashelite — Thu, 28 Aug 2014 09:47:12 GMT

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

Re: count record in application

Thu, 28 Aug 2014 10:02:40 GMT

Hi,

use following function

NoOfRows(['TableName ' ])

Re: count record in application

Thu, 28 Aug 2014 10:28:55 GMT

It won't work

Re: count record in application

schlettig — Thu, 28 Aug 2014 10:36:31 GMT

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

Re: count record in application

Thu, 28 Aug 2014 10:44:53 GMT

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

Re: count record in application

Thu, 28 Aug 2014 10:45:36 GMT

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

Re: count record in application

schlettig — Thu, 28 Aug 2014 10:56:15 GMT

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