topic Re: count records before and after reload in QlikView

count records before and after reload

Anonymous — Tue, 25 Jul 2017 10:17:41 GMT

Hi,

i'm trying to build a function that detects changes after reload, but the following script is not working.

Why are the values of the both variables are the same.

I expected that the value of vRecordsPreLoadCount is 0 before the load, but both variables contains 4.

LET vRecordsPreLoadCount = 'Count(Id)';

data:
LOAD * INLINE [
Id
10
10
11
12
13
];

LET vRecordsPostLoadCount = '=Count(Id)';

Do I have to change the formulas?

Thank you!

Re: count records before and after reload

arvind_patil — Tue, 25 Jul 2017 10:23:03 GMT

HI Matthias,

You need to store it into separate file and after reload pick from it.

Thanks,

Arvind Patil

Re: count records before and after reload

techvarun — Tue, 25 Jul 2017 10:27:23 GMT

Use Table Name not the field name

LET vRecordsPostLoadCount = NoOfRows('data');

Re: count records before and after reload

effinty2112 — Tue, 25 Jul 2017 10:27:26 GMT

Hi Matthias,

In script use NoOfRows('data') instead. Count('Id') can be used in the interface or in the script as part of a aggregration Group by load after which you would need the Peek function to obtain the value.

In this script use NoOfRows('data') instead.

Before load this will be null. After load will equal 5.

Cheers

Andrew

Re: count records before and after reload

techvarun — Tue, 25 Jul 2017 10:37:45 GMT

Try the below script its working

Binary \\Load the same qvw and dont forget to save after every reload;

LOAD * Resident data;

let vRecordsPreLoadCount = NoOfRows('data');

DROP TABLE data;

data:

LOAD * INLINE [

];

LET vRecordsPostLoadCount = NoOfRows('data');