topic Re: Count in QlikView

Count

Mon, 28 Apr 2014 07:28:22 GMT

I Have two columns

A B C

1 passed passed

1 passed ready

i want count of passed and ready for service id's (i.e column a)

i want logic if column B is passed and Column C is passed then consider as passed

but if column B is passed and Column C is ready then consider as ready

Please help

Re: Count

tresB — Mon, 28 Apr 2014 07:31:22 GMT

=Count(If(B='passed' and C='passed' , A))

Note: Use of distinct keyword is upto your requirement.

Re: Count

Mon, 28 Apr 2014 07:34:37 GMT

but if passed and ready combination i need to consider ready

Re: Count

lukaspuschner — Mon, 28 Apr 2014 07:38:04 GMT

if(B='passed' and C='passed','passed','ready')

Re: Count

Mon, 28 Apr 2014 07:41:40 GMT

ok thanks..but i have also combination like

passed not active

passed in-use

Whenever both b and c is passed then i need passed but if i have and any combination with passed i need to use other part not passed

Re: Count

Anonymous — Mon, 28 Apr 2014 07:43:13 GMT

Heyya,check this..!!

Re: Count

jagan — Mon, 28 Apr 2014 07:43:49 GMT

Hi,

Try like this

Passed Count:

=Count({<B={'passed'},C={'passed'}>} A)

Ready Count:

=Count({<B={'passed'},C={'ready'}>} A)

Regards,

Jagan.

Re: Count

Mon, 28 Apr 2014 07:48:43 GMT

PFA,

hope it will help......

Re: Count

Anonymous — Mon, 28 Apr 2014 07:51:55 GMT

Considering the details that u have provided later, I prepared this

have a look at it.

Re: Count

Roop — Mon, 28 Apr 2014 11:33:30 GMT

This sounds as though you need to create a Status Flag/Field on load to provide any of the results that you need that will also be flexible:

if(B = 'Passed',

'Failed'

) as Status,

You can then count the number Passed, Failed or any other stsus that you like very easily and simply

Hope this helps

Re: Count

Mon, 28 Apr 2014 11:45:58 GMT

this should do the trick:

count({<B={'passed'}, C= {'passed'}>}A)

regards,