topic Re: Count a variable in QlikView

Count a variable

Wed, 25 Nov 2020 16:16:04 GMT

I'm new to Qlik,

I have a variable that give 1 or 0 for a list of person (whatever the formula that give 1 or 0 for each person).

How can I count the number of 1 ?
I've tried :

count(

{<Variable>={'1'}} Name

)

But it doesn"t work. Any idea?

Thanks in advance

Re: Count a variable

trdandamudi — Thu, 08 Dec 2016 18:08:24 GMT

May be as below:

Count ({<$(=Variable)={1}>} Name)

Re: Count a variable

bgerchikov — Thu, 08 Dec 2016 18:27:17 GMT

Hi Thirumala,

You cannot use variable this way in Set Analysis. Try to use expression itself instead.

Upload it if you can.

Re: Count a variable

trdandamudi — Thu, 08 Dec 2016 23:57:48 GMT

As Boris pointed out below the above expression will not work.... Below is the expression that will work:

=Count({<Name={"=$(Variable)=1"}>} Name)

Please see the attached sample file for more details. In the sample app I created two fields Id and Name. There are four names which starts with 'A'. I created a Variable and assigned a formula saying if the first letter of the Name is 'A' then 1 else 0. Hope this helps.....

Re: Count a variable

Fri, 09 Dec 2016 20:46:24 GMT

Hi Thirumala,

I wasn't able to open our file as I'm using qlik sense desktop.

but your correction was right! Now it's working !!

Thanks a lot for the help!

Re: Count a variable

Clever_Anjos — Sat, 10 Dec 2016 12:02:01 GMT

As soon as you have only 0´s and 1´s you can Sum(FlagField)