topic Re: Count if Count functionality in QlikView

Count if Count functionality

sivarajs — Fri, 29 Mar 2013 09:39:41 GMT

Hi,

I have a situation like i need to count then i ahve to use same for condition as well

e.g

count(A)

count(if(count(A)>1,A))

But is not working and i dont want to do it in script

-Sivaraj

Fri, 29 Mar 2013 09:44:10 GMT

Hi Siva,

Did you use this?

count(if(column1>1,A))

Regards,

Amay

alexandros17 — Fri, 29 Mar 2013 09:44:46 GMT

You can do:

if(count(A)>1,count(A),'Not Available')

if you want a value you can set your value instead of 'Not Available'

Hope it helps

sivarajs — Fri, 29 Mar 2013 09:55:20 GMT

Hey Amay i have tried the same and i got it but i dint notice that i have got