Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Index/Match formula in QlikView

Hello all

How do i perform Index/Match formula in QlikView. Please see below to get an idea of what I'm trying to do:

Ratio

1st

2nd*

3rd

4th

QUARTILE VALUES

0.12

                            0.25

                      0.43

                      1.00

NO. OF BORROWERS

178

                             175

                       174

                       175

Borrower Name

Borrower's Ratio

Borrower's Quartile

XXXXXXXXXXXXXX

0.38

3rd

* Limit of 2nd quartile is 0.25. Hence, borrower's ratio of 0.38 will be parked under 3rd quartile.

All objects above are recursively calculated depending on what the user selects.

Thanks,

Jeffry

0 Replies