How to count a field

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

Hi,

I have set this variable:

Set ve_PHT = SUM({$<PHT = {'HT', 'DP'}>} #RecFar);

Now I want to make the count independently from the value that takes PHT. Because today it takes only two variables, but maybe in my next updates it can take other values. So I need to make it dynamically.

I try these by they didn't work:

Set ve_PHT = SUM({$<PHT={"$(=LEN(PHT)>0)"}>} #RecFar);

Set ve_PHT = SUM({$<PHT={'*'}>} #RecFar);

Any suggestions on how can it be done?

Re: How to count a field

Saravanan_Desingh — Tue, 21 Apr 2020 16:49:08 GMT

Use LET instead of SET and double quote. This is like PHT Is Not NULL.

Let ve_PHT = SUM({$<PHT={"*"}>} #RecFar);

topic How to count a field in QlikView

How to count a field

Re: How to count a field