100 conditions can not check

[#1]

Hi all,

I have challenge. I have following conditions has to check to get answer IN Scope , Out Scope, pending.

Please suggest me a simplest way to do it.

[Anil_Babu_Samineni]

What you mean simplest way? I don't think whether i can possible in simplest way. Will you able to provide sample excel which has formula in excel so then we can work for you in qlikview

[#3]

As of now we don't have data for same. but what is possible solution to get same output.?

[Anil_Babu_Samineni]

I think you need more than 10 joins to achieve this? And data structure and output need is very clumsy so i can't. May be wait, until some one help