Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
SK
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.
See this document: http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis
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 ?
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,
SK
Thanks very much .
It works for me