topic Re: count statement with 2 conditions in QlikView

count statement with 2 conditions

samuel_brierley — Thu, 13 Mar 2014 11:38:31 GMT

I have the following formula and for the life of me cant work out whats wrong with it. it produces a number the number is not correct.

pretty obvious but for clairty its supposed to count how many cars that have a length between 10 and 6 meters. Ive tried both ways i.e 10m first and then 6 vice versa.

thanks for any help

count({$<Length = {'<10'},Length = {'>6'} >} Length)

Re: count statement with 2 conditions

Thu, 13 Mar 2014 11:52:12 GMT

count({$<Length={">6<10"}>}'ID')

Re: count statement with 2 conditions

Thu, 13 Mar 2014 11:53:55 GMT

Hi,

Try like this

=Count(Distinct {<Length={">=6<10"}>}Length)

Regards

Kumar

Re: count statement with 2 conditions

VishalWaghole — Thu, 13 Mar 2014 11:55:14 GMT

Hello samuel,

Please try this, hope this will work for you.

=Count({<Length = {'<6','>8'}>}Length)

- Regards,

Vishal Waghole.

Re: count statement with 2 conditions

er_mohit — Thu, 13 Mar 2014 12:00:27 GMT

Try this

=Count({<Length = {">6<10"}>}Car)

=Count({< Car={"=Count({<Length = {">6<10"}>}Car)"}>}Car)

Re: count statement with 2 conditions

amit_saini — Thu, 13 Mar 2014 12:11:06 GMT

Hi Samuel,

Please try this:

=Count({<Length = {">6<10"}>}Cars)

Thanks,

Re: count statement with 2 conditions

Thu, 13 Mar 2014 12:18:25 GMT

try this

count({<Length={">=6<=10"}>}Cars)

Re: count statement with 2 conditions

samuel_brierley — Thu, 13 Mar 2014 12:20:08 GMT

thanks for the help