Discussion Board for collaboration related to QlikView App Development.
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
Go to Solution.
take a bar chart and in expression
use below code
or you can
see the attached file
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.
Artur - is it possible that you can maybe ellaborate please - maybe with an example.
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.
Why didn't you just count the number of employee and check the option "Relative" ?
relative is not serving the purpose i belive
Thanks Sunil, you fixed my problem. The 'relative' option doesn't fit for now, but good to knwo this option.
Much Thanks! Arthur
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 .
Very helpful. I had a very similar problem and this method worked perfectly with wildmatch.