topic Re: Why i can't count in a variable in the load script? in QlikView

Why i can't count in a variable in the load script?

qlikconsultant — Tue, 10 Oct 2017 10:09:01 GMT

Hi I have the following code in the load script:

LET vCountCustomers=count(distinct usercode);

But as result i get nothing.

Re: Why i can't count in a variable in the load script?

marcus_sommer — Tue, 10 Oct 2017 10:12:09 GMT

Try it with: LET vCountCustomers = fieldvaluecount('usercode')

- Marcus

Re: Why i can't count in a variable in the load script?

sunny_talwar — Tue, 10 Oct 2017 10:12:22 GMT

I guess this functionality is not directly available, but if you want, you can calculate Count() in a table load and then store its value in a variable using Peek() function....

Temp:

LOAD count(distinct usercode) as CountCust

Resident SomeTable;

LET vCountCustomers = Peek('CountCust');

DROP Table Temp;

Re: Why i can't count in a variable in the load script?

Peter_Cammaert — Tue, 10 Oct 2017 10:28:14 GMT

Indeed. In a Load Script, aggregation functions like Sum(), Count() Min(), Max() and the others only work if they are used in a LOAD or SQL SELECT statement. AFAIK they don't even work on Fields, just on Table Columns.