topic 'Count if' of simple text values in QlikView

'Count if' of simple text values

Mon, 28 Nov 2011 22:04:22 GMT

Dear All,

I can't manage to simply count particular text values in a field with the 'count if' expression. Who could help me with this?

Much thanks. Arthur

swuehl — Mon, 28 Nov 2011 22:27:55 GMT

Not sure if I completely understand, but maybe like

=sum( if(match(YOURFIELD,'TextA','TextB','TextC'),1,0) )

You could also use Wildmatch to use wildcards in your search.

Mon, 28 Nov 2011 22:45:28 GMT

Artur - is it possible that you can maybe ellaborate please - maybe with an example.

Tue, 29 Nov 2011 08:27:06 GMT

See the images.

I want a bar chart showing me the percentage of MALE employees / Total number of employees.

So how can I count 'true' and divide this by total number of employees.

It must be 60% but I can't figure out how to enclose this into an graph expression.

Much thanks to help me as beginner.

SunilChauhan — Tue, 29 Nov 2011 08:36:04 GMT

take a bar chart and in expression

use below code

Count(if(Male='true',Employee))/count(Male)

or you can

see the attached file

Tue, 29 Nov 2011 08:41:26 GMT

Why didn't you just count the number of employee and check the option "Relative" ?

SunilChauhan — Tue, 29 Nov 2011 08:49:38 GMT

relative is not serving the purpose i belive

Tue, 29 Nov 2011 08:53:06 GMT

Thanks Sunil, you fixed my problem. The 'relative' option doesn't fit for now, but good to knwo this option.

Much Thanks! Arthur

SunilChauhan — Tue, 29 Nov 2011 08:56:04 GMT

first of all mark this as correct .which will indicate issue is closed .

relative is best suited where distribution is required . like out of 100% , 20% is a,30% is b, 50% is a .

Tue, 13 Dec 2016 14:58:25 GMT

Very helpful. I had a very similar problem and this method worked perfectly with wildmatch.