Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

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

Hi All ,

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

ipbx.png

2.png

Thanks & Regards

Shekar

1 Solution

Accepted Solutions
sunny_talwar

Also one last one... when you have PNB in input box, why is bad performer's empty? shouldn't these two show up?

Capture.PNG

If you agree with the above two... then check the attached sample

View solution in original post

9 Replies
shekhar_analyti
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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&T201820BOIBonds
Orexigen Therapeutics, Inc.2018400PNBOTHERS

Thanks & Regards

Shekar

sunny_talwar

Here we have SBI in 2017, but you need A&Y for 2018 for better than SBI?

Capture.PNG

Capture.PNG

and you don't wany 2017's 450? That is sort of what is confusing me right now

shekhar_analyti
Specialist
Specialist
Author

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&Y2017200SBIGL
A&Y2018200SBIGL
sunny_talwar

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

Capture.PNG

sunny_talwar

Also one last one... when you have PNB in input box, why is bad performer's empty? shouldn't these two show up?

Capture.PNG

If you agree with the above two... then check the attached sample

shekhar_analyti
Specialist
Specialist
Author

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