topic Re: Need to arrange a filter drop down in App Development

Need to arrange a filter drop down

AbiramiN — Mon, 17 Mar 2025 07:39:56 GMT

Hi, I want to bring the FX ADj Working Forecast to last place, all the other in same sequence.

And I tried dual, match, wild match and using variables, I am getting the same order as in Pic.

Please help me out with this.

Re: Need to arrange a filter drop down

VBD — Mon, 17 Mar 2025 07:54:37 GMT

Hello, can you send the expressions that you tried ?

It should be work

Re: Need to arrange a filter drop down

VBD — Mon, 17 Mar 2025 08:04:50 GMT

best way to do that is in the script with a dual :
load dual(MYFIELD,id) as MYFIELD inline
[MYFIELD, id
ACTUAL,1
FX ADJ WORKING FC,7
FY24 BUDGET,2
FY24 FC1,3
FY24 FC2,4
FY24 FC3,5
WORKING FORECAST,6
];

But it should be work with an if in your sorting expressions :

if(MYFIELD = 'ACTUAL',1,

if(MYFIELD = 'FY24 BUDGET',2,

if(MYFIELD = 'FY24 FC1',3,

if(MYFIELD = 'FY24 FC2',4,

if(MYFIELD = 'FY24 FC3',5,

if(MYFIELD = 'WORKING FORECAST',6,

if(MYFIELD = 'FX ADJ WORKING FC',7)))))))

regards

Re: Need to arrange a filter drop down

AbiramiN — Mon, 17 Mar 2025 08:05:25 GMT

2.IF([Var Analysis Baseline 1]='ACTUAL',1,
IF([Var Analysis Baseline 1]='FY24 BUDGET',2,
IF([Var Analysis Baseline 1]='FY24 FC1',3,
IF([Var Analysis Baseline 1]='FY24 FC2',4,
IF([Var Analysis Baseline 1]='FY24 FC3',5,
IF([Var Analysis Baseline 1]='FY24 FC4',6,
IF([Var Analysis Baseline 1]='FY24 FC4 FX',7,
IF([Var Analysis Baseline 1]='Working Forecast',8,
IF([Var Analysis Baseline 1]='FX Adj Working Forecast',9)))))))))

Re: Need to arrange a filter drop down

AbiramiN — Mon, 17 Mar 2025 08:08:55 GMT

Hi, Thank you

But those approaches are not working for me.

Re: Need to arrange a filter drop down

VBD — Mon, 17 Mar 2025 08:10:05 GMT

can you send a screen of your filter panel properties ?

Re: Need to arrange a filter drop down

AbiramiN — Mon, 17 Mar 2025 08:14:40 GMT

Sure,

Re: Need to arrange a filter drop down

VBD — Mon, 17 Mar 2025 08:17:17 GMT

Is that an extension ? can you try in the "true" filter panel

Re: Need to arrange a filter drop down

AbiramiN — Mon, 17 Mar 2025 08:26:10 GMT

Hi, i will try once. Thank you