topic Sum Conditional in Set Analysis in QlikView

Sum Conditional in Set Analysis

Anonymous — Thu, 29 Mar 2012 09:11:47 GMT

HI,

This statement seems to not be working at all

=count({<{$(=sum(InvoiceFlag))}={'$(>1)'}>} distinct CompanyID)

The aim of the expression is to count the CompanyID's where the sum of the invoice flags is greater then 1.

Regards

Sum Conditional in Set Analysis

sivarajs — Thu, 29 Mar 2012 09:23:48 GMT

Hi,

store sum(invoice fllag) in a seperate variable

Then use syored variable here in the expression

Sivaraj S

Sum Conditional in Set Analysis

Thu, 29 Mar 2012 09:25:25 GMT

Take sum(Invoiceflag) in a variable say var1

and use this:

=count({<$(var1)={'>1'}>}distinct CompanyID)

Sum Conditional in Set Analysis

Thu, 29 Mar 2012 09:29:22 GMT

=count({<var1'>1'>}distinct CompanyID)

Sum Conditional in Set Analysis

Anonymous — Thu, 29 Mar 2012 09:37:00 GMT

Hey Acrobat,

Thanks for this input.

This solution doesnt work, I think it is because the sum in the variable is used across all of the companies whilst the actual expression is for one company.

That is why I tried to package this all into one expression with set analysis.

Re: Sum Conditional in Set Analysis

Thu, 29 Mar 2012 09:47:45 GMT

Hi hamishimrie,

just use this

=count( {<InvoiceFlag={ '>1'} >} CompanyId)

it works!!

please find attachement eee.qvw

Warms Regards,

Anant Dubey

Re: Sum Conditional in Set Analysis

CELAMBARASAN — Thu, 29 Mar 2012 09:54:34 GMT

Hi,

Check with this

=count({<CompanyID={"=sum(InvoiceFlag)>1"}>} distinct CompanyID)

Celambarasan

Re: Sum Conditional in Set Analysis

Anonymous — Thu, 19 Jul 2018 04:12:24 GMT

hi Celambarasan,

Is it possible to

=count({<CompanyID={"=sum(InvoiceFlag)>1 & < 5" }>} distinct CompanyID)

something like that.

Thx.

Best Regards,

Louis