topic Count function in QlikView

Count function

Wed, 19 Mar 2014 10:27:01 GMT

Hello,

I am an new member and I would like to set an expression with a count function.

I have a data :

I would like to count a number of names which will be restricted by category 'XXX' and (P1+31 - P2 - 32) >0

I also attached QV for support

Another issue I have is count how many largest 'name' will make 80% (P1+31) for subcategory.

If someone could help I will be grateful .

Many thanks in advance

Nicole-Smith — Wed, 19 Mar 2014 14:32:33 GMT

sanchopancho wrote:

I would like to count a number of names which will be restricted by category 'XXX' and (P1+31 - P2 - 32) >0

Your expression should be:

Count({$<Name={'=[31]+[P1]-[32]-[P2]>0'},Category ={'XXX'}>} Name)

sanchopancho wrote:

Another issue I have is count how many largest 'name' will make 80% (P1+31) for subcategory.

Thu, 20 Mar 2014 09:13:02 GMT

Hi Nicole,

Thanks for your reply.

Nicole Smith wrote:

Your expression should be:

Count({$<Name={'=[31]+[P1]-[32]-[P2]>0'},Category ={'XXX'}>} Name)

I tried it and I have an "error in set modifier ad hoc element list" in my expression .

Also there is a red mark under ]-[ between second subtraction.

Do you have any idea why ?

Thu, 20 Mar 2014 10:06:00 GMT

Hi,

Check if attached expression works for you.

And your second requirement should be possible using teh approach that Nicole mentioned in her reply.

Rgds,

Thu, 20 Mar 2014 10:28:11 GMT

Thanks very much .

It works for me