topic Re: Variable inside count function in QlikView

Variable inside count function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Why will the count function not return a result when a variable referring to a column is used as the parameter?

Loan_listing:
LOAD
LOAN_NUMBER, 
     PRODUCT, 
     PROD_DESC, 
     CURRENCY as loan_currency, 
     Evaluate(AMOUNT) as loan_amt, 
     'Loans' as Data
FROM
[parsed parameters\loanlisting.qvx]
(qvx);

let name = FieldName(1, 'Loan_listing');
let nom = count(FieldName(1, 'Loan_listing'));

why is nom always empty? shouldn't it have the count of LOAN_NUMBER?

Re: Variable inside count function

HirisH_V7 — Wed, 15 Nov 2017 11:50:44 GMT

Try using this,

let nom = FieldValuecount(FieldName(1, 'Loan_listing'));

-Hirish

Re: Variable inside count function

Sergey_Shuklin — Wed, 15 Nov 2017 11:58:28 GMT

Hello!

Try this functions:

LET nom = NoOfRows('Loan_listing') //for all rows

LET nom = FieldValueCount('LOAN_NUMBER') //for distinct values of the field

Re: Variable inside count function

HirisH_V7 — Wed, 15 Nov 2017 12:27:15 GMT

Bro, 'NoOfRows' it will not be allowed prior to Fieldname Function.

Re: Variable inside count function

Sergey_Shuklin — Wed, 15 Nov 2017 12:32:07 GMT

Hello!

I didn't use it with Fieldname() function.

Re: Variable inside count function

Anonymous — Wed, 15 Nov 2017 13:03:05 GMT

Your answer works but why won't click accept fieldname() inside of count?

Re: Variable inside count function

HirisH_V7 — Wed, 15 Nov 2017 14:07:52 GMT

Yup! But he wants it with specified field.

Re: Variable inside count function

HirisH_V7 — Wed, 15 Nov 2017 14:22:19 GMT

Count and Sum will not work directly. we need use it like this,

Data_New:
Load
Count(YourField) as count
Resident Data Group By OtherField or currentField;

Then you need to call that count field into a , let variable using peek.