Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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