topic Re: CountIf help in QlikView

CountIf help

danielnevitt — Thu, 12 Nov 2015 11:12:38 GMT

Hi,

I have the following expression and I would really appreciate some help.

=Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt)

Is it possible to only show results where the result of the count is greater than or equal to 2?

Thanks,

Daniel

Re: CountIf help

sunny_talwar — Thu, 12 Nov 2015 11:13:58 GMT

May be this:

If(Count({<extended_amt = {'>=$(vInputAmount)'}>} extended_amt) >=2, Count({<extended_amt ={'>=$(vInputAmount)'}>} extended_amt))

Re: CountIf help

Anonymous — Thu, 12 Nov 2015 11:15:03 GMT

is this?

=if(Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt)>=2, Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt))

Re: CountIf help

danielnevitt — Thu, 12 Nov 2015 11:15:04 GMT

Thank you, that works perfectly.

Regards,

Daniel

Re: CountIf help

Kushal_Chawda — Thu, 12 Nov 2015 11:16:16 GMT

Yes, you can do it

if( Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt)>=2,

Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt),0)

Re: CountIf help

sunny_talwar — Thu, 12 Nov 2015 11:16:46 GMT

Awesome

Re: CountIf help

danielnevitt — Thu, 12 Nov 2015 12:34:16 GMT

Thanks for the above responses.

Unfortunately when validating my data, I noticed that it returns incorrect values for the count.

Even if I enter Count(extended_amt the values returned are incorrect. ie it returns two when there is only one item matching this value. Is there something I am doing wrong?

Regards,

Daniel

Re: CountIf help

Anonymous — Thu, 12 Nov 2015 12:38:46 GMT

didnt understand your requirement what exactly you want but try Distinct:

=if(Count({<extended_amt={'>=$(vInputAmount)'}>} extended_amt)>=2, Count({<extended_amt={'>=$(vInputAmount)'}>} distinct extended_amt))

Re: CountIf help

sunny_talwar — Thu, 12 Nov 2015 12:41:26 GMT

Yes, I agree with Balraj, amy be you need this:

If(Count(DISTINCT {<extended_amt = {'>=$(vInputAmount)'}>} extended_amt) >=2, Count(DISTINCT {<extended_amt ={'>=$(vInputAmount)'}>} extended_amt))

Re: CountIf help

syukyo_zhu — Thu, 12 Nov 2015 12:47:09 GMT

Can you upload your application Qvw?