Sorting expression

[pawwy1415]

Hi,

I have below expression used in dimension and I want to do sorting

= pick(match(MetricID,27,31,394,398,222,224,360,364,368,372,1141,1143,154,156,160,162,213,215,380,382)

     ,'PBT','Provisions','PBT','Provisions','Income','Income','Costs','Costs','Costs','Costs','PAT','PAT',

     'Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs')

sorting should be like

Income

Costs

Provisions

PBT

PAT

RWA

I used below expression in sorting..

= pick(match(MetricID,222,224,360,364,368,372,31,398,27,394,1141,1143,154,156,160,162,213,215,380,382)

     ,1,1,2,2,2,2,3,3,4,4,5,5,

     6,6,6,6,6,6,6,6)

but it doesn't work.. it's come in below order

Total RWAs

Costs

income

Provisions

PBT

PAT

Could you please see if I am doing something wrong in sorting?

[pawwy1415]

This is in qlik sense

[sunny_talwar]

What if you just use this

Match(Only({1} MetricID), 222,224,360,364,368,372,31,398,27,394,1141,1143,154,156,160,162,213,215,380,382)

[effinty2112]

Hi,

Try this as your sort expression:

Match(

pick(match(MetricID,27,31,394,398,222,224,360,364,368,372,1141,1143,154,156,160,162,213,215,380,382)

     ,'PBT','Provisions','PBT','Provisions','Income','Income','Costs','Costs','Costs','Costs','PAT','PAT',

     'Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs')

,'*Income*','*Costs*','*Provisions*','*PBT*','*PAT*','*RWA*')

Good luck

Andrew

[Anil_Babu_Samineni]

Try this?

Match(MetricID, 'Total RWAs', 'Costs', 'income', 'Provisions', 'PBT', 'PAT')

[pawwy1415]

Hi all,

tried all but none of them working

[effinty2112]

Hi,

I had a typo, try:

WildMatch(

pick(match(MetricID,27,31,394,398,222,224,360,364,368,372,1141,1143,154,156,160,162,213,215,380,382)

     ,'PBT','Provisions','PBT','Provisions','Income','Income','Costs','Costs','Costs','Costs','PAT','PAT',

     'Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs','Total RWAs')

,'*Income*','*Costs*','*Provisions*','*PBT*','*PAT*','*RWA*')

[pawwy1415]

it's coming in this order now..still not working

[sunny_talwar]

May be give this a short

=Match(

Pick(

Match(Only({1} MetricID),27,31,394,398,222,224,360,364,368,372,1141,1143,154,156,160,162,213,215,380,382),

'PBT', 'Provisions', 'PBT', 'Provisions', 'Income', 'Income', 'Costs', 'Costs', 'Costs', 'Costs', 'PAT', 'PAT', 'Total RWAs', 'Total RWAs', 'Total RWAs', 'Total RWAs', 'Total RWAs', 'Total RWAs', 'Total RWAs', 'Total RWAs'),

'Total RWAs', 'Costs', 'Income', 'Provisions', 'PBT', 'PAT')

[pawwy1415]

it's coming this one..