topic Re: Counting text objects in QlikView

Counting text objects

Thu, 28 Nov 2013 15:49:17 GMT

Hi again,

Another question for you. I want to count a set of post where one of the variables is a text entry. I have a few different statuses; "Draft", "Approved" and "Evaluation" and in an chart expression I am trying to do something like this:

COUNT(DISTINCT IF(status<>"Approved",name))

What this is to result in is a number of the post where the status is "Approved". Seems easy enough, but I cant get it to work. Thoughts?

Cheers,

Re: Counting text objects

Gysbert_Wassenaar — Thu, 28 Nov 2013 15:53:59 GMT

Try count({<status-={'Approved'}>} distinct name). Make sure to use the exact case-sensitive field names and values. If you need more help, please post a sample document that demonstrates the problem.

Re: Counting text objects

swuehl — Thu, 28 Nov 2013 15:58:55 GMT

COUNT(DISTINCT IF(status<>"Approved",name))

What this is to result in is a number of the post where the status is "Approved". Seems easy enough, but I cant get it to work. Thoughts?

Do you want to get the result for status is equal 'Approved' or is not equal 'Approved'? Your expression is calling for is not.

If you want to check for equal, then use either

=COUNT(DISTINCT IF(status = 'Approved',name))

{note also the single quotes}

=COUNT({<status = {Approved}>} distinct name)

Re: Counting text objects

Fri, 29 Nov 2013 08:05:40 GMT

excellent! thank you!

naturally i meant "=" and not "<>", that was just a brain crash on my end, good that you caught that . i think my biggest problem with this was mainly that i was using a " when i should have been using '. you live and learn i guess ...