topic Re: How to refer to the rows in a straight table + quartiles in QlikView

How to refer to the rows in a straight table + quartiles

Thu, 23 Apr 2015 08:26:45 GMT

Hi,

I have a straight table with an computed expressions and i have to make the quartiles for each of this expression according the banks (field [banks]).

The table should look like this:

Quartiles	ROA	ROE
1Q (for banks)
2Q (for banks)
3Q (for banks)
4Q (for banks)

I have a field [banks], ROA and ROE are computed expressions. How can i refer to the row which contain ROA and ROE? I'm looking for a function which have a similar action as column(), but refers to the rows. I added a dimension which almost do it, but only for one field, with an expression if. How can I do it?

Re: How to refer to the rows in a straight table + quartiles

Thu, 23 Apr 2015 08:32:06 GMT

send me sample qvw file

Re: How to refer to the rows in a straight table + quartiles

Thu, 23 Apr 2015 09:03:20 GMT

I attached qv file. I want to sort values by banks and make quartiles for them in one table.

Re: How to refer to the rows in a straight table + quartiles

Thu, 23 Apr 2015 09:10:19 GMT

I tried to do it by writing a calculated dimension:

=if(FXX00120 <= fractile(TOTAL FXX00120, 0.25), 1,

if(FXX00120 <= fractile(TOTAL FXX00120, 0.5), 2,

if(FXX00120 <= fractile(TOTAL FXX00120, 0.75), 3,

if(FXX00120 <= fractile(TOTAL FXX00120, 1), 4,

))))

But i works only for one expression

Re: How to refer to the rows in a straight table + quartiles

buzzy996 — Thu, 23 Apr 2015 09:32:40 GMT

seems to be still some thing is missgin to undestand this issue!,how u want o define 1Q (for banks),2 Q (for banks)..etc?

if it's based on banks,all abcnk will come under same Q1 or not? pls explain little bit more.

Re: How to refer to the rows in a straight table + quartiles

Thu, 23 Apr 2015 09:49:33 GMT

1Q is first quartile. At first I must sort indicators (ROA, ROE) for banks:

e.g.

-0.04%, 0.02%, 0.03%, 0.06%,0.11%, 0.15%,0.27%, 0.3%

n=8

n/4=2

1Q=0.02%

2Q=0.06%

3Q=0.15%

4Q=0.3%

The same for ROE. I need to display this 1Q,2Q,3Q,4Q values for this two indicators in one table.

Re: How to refer to the rows in a straight table + quartiles

buzzy996 — Thu, 23 Apr 2015 09:57:47 GMT

sorry for asking again,how u came to know 1Q=0.02%?

Re: How to refer to the rows in a straight table + quartiles

Thu, 23 Apr 2015 10:14:33 GMT

After sorting this already computed values you count, how many values do you have. There are 8 banks, so n=8. Quartiles divide population on a 4 equal subpopulation. So in one subpopulation you have 2 banks. In order to compute quartiles you take a value for 2th, 4th, 6th and 8th bank in a rank. I need to display this values and earlier bolded them.