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

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

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

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

Thanks & Regards

Shekar

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

shekhar_analyti — Tue, 03 Apr 2018 16:05:39 GMT

stalwar1‌

Hi Sunny Bhai ,

Is this possible or its unrealistic Requirement ?

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

sunny_talwar — Tue, 03 Apr 2018 16:21:10 GMT

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

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

shekhar_analyti — Wed, 04 Apr 2018 08:15:06 GMT

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

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

sunny_talwar — Wed, 04 Apr 2018 08:57:32 GMT

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

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

shekhar_analyti — Wed, 04 Apr 2018 09:04:31 GMT

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

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

sunny_talwar — Wed, 04 Apr 2018 09:08:31 GMT

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

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

sunny_talwar — Wed, 04 Apr 2018 09:11:02 GMT

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

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

shekhar_analyti — Thu, 05 Apr 2018 09:29:43 GMT

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

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

sunny_talwar — Thu, 05 Apr 2018 11:10:05 GMT

So it was there to confuse us