topic Re: Count lines higher than other lines in QlikView

Count lines higher than other lines

Mon, 16 Jun 2014 07:07:12 GMT

Hello everyone,

I need your help about a set analysis expression.

I have to count the number of Lines higher than Invoice AND whose Invoice is not equal to 0.

To do that, I did this expression :

=Count({<Lines={"=Lines>Invoice"}*{"=Invoice<>0"}>}[Lines])

But the result does not seem very correct..

Do you have any idea to improve the expression ?

Thanks

Re: Count lines higher than other lines

Mon, 16 Jun 2014 07:10:02 GMT

=Count({<Lines={">=Invoice"}, Invoice={">=0"}>} Lines)

Re: Count lines higher than other lines

Mon, 16 Jun 2014 07:11:34 GMT

try this

=count(If((lines>invoice and invoice<>0),lines))

Re: Count lines higher than other lines

Mon, 16 Jun 2014 07:13:32 GMT

try:

Count({<Lines = p({<Lines = {'>=$(=Invoice)'}>}Lines)*p({<Invoice = {'>=$(=0)'}>}Lines) >}Lines

Re: Count lines higher than other lines

its_anandrjs — Mon, 16 Jun 2014 07:14:10 GMT

Some change

=Count({<Lines={ ' >Invoice ' }, Invoice = {">0"}>} Lines)

Re: Count lines higher than other lines

tresB — Mon, 16 Jun 2014 07:14:14 GMT

This sort of set analysis gives right result only if the comparison field (here Lines) has unique values (i.e - a key field). Otherwise, try using if like: =Count( If(Lines>Invoice and Invoice<>0 ,[Lines]) )

Re: Count lines higher than other lines

Mon, 16 Jun 2014 07:30:29 GMT

Thank you everyone for your response !