topic Re: Count function and expression in QlikView

Count function and expression

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

Hello all,

I am finding some difficulty in using the count function, but using an expression to define what to count. Here is what I am trying to do:

=count({<left(aVar ,4)= {'Past'}>} aVar) / Count(aVar)

All I am trying to do with the above count is count only the variable that starts with the word "Past" and dividing it by the total count of the variable.

I get an error on the above statement and have no idea how to fix. Any help is much appreciated.

thank you

Roberto

Re: Count function and expression

sunny_talwar — Mon, 04 Dec 2017 16:30:08 GMT

Is aVar a field or variable? If it is a field, try this

=Count({<aVar = {"Past*"}>} aVar)/Count(aVar)

Re: Count function and expression

trdandamudi — Mon, 04 Dec 2017 16:38:13 GMT

One more way may be as below:

=Count({<aVar= {"=Left(aVar ,4)= 'Past' "}>} aVar) / Count(aVar)