topic Re: Count condition in QlikView

Count condition

Mon, 05 Aug 2013 13:52:31 GMT

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.

Re: Count condition

shree909 — Mon, 05 Aug 2013 14:17:23 GMT

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))

Re: Count condition

Mon, 05 Aug 2013 15:23:47 GMT

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

Re: Count condition

nagaiank — Mon, 05 Aug 2013 15:27:24 GMT

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

Re: Count condition

Mon, 05 Aug 2013 15:42:43 GMT

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.

Re: Count condition

nagaiank — Mon, 05 Aug 2013 15:44:40 GMT

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.