Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have percentile data in the following format
Percentile | X |
0.1 | 58 |
0.2 | 64 |
0.3 | 72 |
0.4 | 85 |
0.5 | 99 |
0.6 | 105 |
0.7 | 123 |
0.8 | 132 |
0.9 | 136 |
For any given value of X I need to be able to output the percentile above and below the value. For example if X was 102 I need to be able to output 0.5 and 0.6.
In Excel I would use a Match() function but I don't think that Match() in Qlik works the same way? Please correct me if i'm wrong!
Thanks in advance for any help!
How X was 102 and will that come as source or user will enter in the input box?
Hi, sorry I couldn't reply sooner.
X is loaded with the data so the user will not be able to change the value but it may change when the data is refreshed.