topic Count "Text" in a Textbox in QlikView

Count "Text" in a Textbox

Wed, 11 Jan 2012 17:34:00 GMT

Hi,

I've got al Listbox

System | on_off

------------------------------

System3 | on

System1 | off

System33 | on

System78 | on

System133 | off

Now I want to crate a textbox where i can count all systems which are 'on'.

=count(on_off =1) & 'Systems are on'

Doesn't work, where is the problem??

Thanks

Wed, 11 Jan 2012 17:45:31 GMT

Try it this way

=count(if(on_off=1, system))

You could count either column.

swuehl — Wed, 11 Jan 2012 17:45:35 GMT

try either

= count(if (on_off = 'on', on_off)) & ' Systems are on'

=count({<on_off = {'on'}>} on_off) & ' Systems are on'

hope this helps,

Stefan