How to fetch best and worst performing data rows based on Value in Input Box ?

[shekhar_analyti]

Hi All ,

How to fetch best and worst performing data rows based on Value in Input Box ?

Thanks & Regards

Shekar

[shekhar_analyti]

stalwar1‌

Hi Sunny Bhai ,

Is this possible or its unrealistic Requirement ?

[sunny_talwar]

Bad seems to be partially working... not sure I understand the logic... can you explain the requirement in words.

[shekhar_analyti]

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

[sunny_talwar]

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

[shekhar_analyti]

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

[sunny_talwar]

One more.... why is M&L not better performing? The output you are requesting isn't including it....

[sunny_talwar · Accepted solution]

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

[shekhar_analyti]

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

[sunny_talwar]

So it was there to confuse us