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.
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
As of now we don't have data for same. but what is possible solution to get same output.?
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
Retrieving data ...