Count condition

[#1]

Hi All,

I have a large data table and I'm trying to put together an expression in a LED display chart, but I just can't get it to work!

Two of the fields are Service and Build...

Service          Build

Service A          B

Service B          B

Service B          F

Service C          F

Service D          B

Service D          F

etc.

I need the LED display to show the count of the number of services that have a build of both B and F.

Any help gratefully received! Thanks.

[shree909]

Hi ,

If i understood clearly for  services listbox u want to show the count of B and F  in the same list box

Take services as listbox, then go the properties and expression tab of the listbox and add an expression

=count({<Build ={'B','F'}>}Service)

or try this

=if(match(Build,'B','F'),0,count(Service))

[#3]

Hi Shree909, Thanks for the reply.

I'm trying to get the number of services that are listed against both the builds - B and F.

But not those that are just B or F.

So, in the small example above, the result should be just 2... Service B and Service D.

Regards

[nagaiank]

You may use And-Mode listbox. The Qlikview Reference manual explains this in detail.

[#5]

Thanks Krishnamoorthy.

In the list box I created using the advice from shree909 the And-Mode checkbox is greyed-out.

Also, I'm trying to get just one value returned, displayed as an LED gauge chart (I dont need the service(s) displayed.

[nagaiank]

The And-Mode checkbox will be available (not greyed-out) when the conditions for such listboxes are met. The conditions are discussed in the Reference Manual.