Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to fetch best and worst performing data rows based on Value in Input Box ?
Thanks & Regards
Shekar
Also one last one... when you have PNB in input box, why is bad performer's empty? shouldn't these two show up?
If you agree with the above two... then check the attached sample
Bad seems to be partially working... not sure I understand the logic... can you explain the requirement in words.
Hi Sunny Bhai ,
Requirement as it goes :
If user selects SBI in Input box , then
First Table should show all the details of Service_Entity other than SBI which have Amount lower than SBI for similar year and product
example .
In year 2018 Amount for SBI is 100 for Product Bonds ..
In same year for Rest Two Service_Entity (BOI AND PNB) , ONLY record exist for BOI for Product Bonds , whose Amout is 20 and lesser than 100 of SBI . Hence captured . But record for same product in same year does not exist for PNB .
Similarly for Client Orexigen Therapeutics, Inc. for PNB Amount value is 400 which is lesser than 900 of SBI for product 'OTHERS'
L&T | 2018 | 20 | BOI | Bonds |
Orexigen Therapeutics, Inc. | 2018 | 400 | PNB | OTHERS |
Thanks & Regards
Shekar
Here we have SBI in 2017, but you need A&Y for 2018 for better than SBI?
and you don't wany 2017's 450? That is sort of what is confusing me right now
Sorry Bhai , its mistake from my end . Apologies !! ..
Actually input data should have year as 2018 for A&Y for product GL and Service Entity as SBI
A&Y | 2017 | 200 | SBI | GL |
A&Y | 2018 | 200 | SBI | GL |
One more.... why is M&L not better performing? The output you are requesting isn't including it....
Also one last one... when you have PNB in input box, why is bad performer's empty? shouldn't these two show up?
If you agree with the above two... then check the attached sample
Thank You Bhai Ji ... It was left for the purpose that , if the logic for above two banks work fine , let Qlikview take care for PNB
So it was there to confuse us