Discussion Board for collaboration on QlikView Scripting.
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
=Count(If(B='passed' and C='passed' , A))
Note: Use of distinct keyword is upto your requirement.
but if passed and ready combination i need to consider ready
if(B='passed' and C='passed','passed','ready')
ok thanks..but i have also combination like
passed not active
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
Try like this
hope it will help......
Considering the details that u have provided later, I prepared this
have a look at it.
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',
) as Status,
You can then count the number Passed, Failed or any other stsus that you like very easily and simply
Hope this helps