Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone
How to use set analysis to sort some field's attribute?I dont want to use match function for these
i have match function like this
Match(ancestor_name,'Total Assets','Fixed Assets less Accumulated Depreciation','Cash and Cash Equivalents','Current assets','Current Liabilities','Working capital',
'Operating working capital (ex FS)','Current Ratio (ex FS)','Net Worth','Working Capital Loans','Capital Employed','RONW %','ROCE %','Operating ROCE %','WACB %',
'Debt/ Equity','Interest coverage ratio','Debt/ EBITDA (ex FS)')
as i wanted then in my table as they are written,but problem is that when I'm selecting one field ,its position in the table got first,
i want to select them and as i select them it should be in that fixed position
thank you
You can create an inline table with the field values you are using in your match, and a second field that holds either the sort order as number or as a dual value. Then use the second field (when created as dual) as dimension.
Or try
=Match(only({1} ancestor_name),'Total Assets','Fixed Assets less Accumulated Depreciation','Cash and Cash Equivalents','Current assets','Current Liabilities','Working capital',
'Operating working capital (ex FS)','Current Ratio (ex FS)','Net Worth','Working Capital Loans','Capital Employed','RONW %','ROCE %','Operating ROCE %','WACB %',
'Debt/ Equity','Interest coverage ratio','Debt/ EBITDA (ex FS)')
Not sure if I understand.
Set analysis purpose is to chose a working set of your data model for aggregations. It has nothing to do with sorting in principle.
So, to clarify your request, please tell us, how your field values look like, then where you want to sort the field (script / chart) and how the sort should work (by number / by text, by something else?).
on sort tab
my expression field have the logic of match function,i want to change it with set analysis
Hi,
and if you load this dimension in the script with the correct order ?
Then you could use the load order to sort, or with the dual function.
Hello BBI_MBA_76
my dimensions are attributes of a field 'str_description'
I can load str_description but how can i load attributes of str_description
You can create an inline table with the field values you are using in your match, and a second field that holds either the sort order as number or as a dual value. Then use the second field (when created as dual) as dimension.
Or try
=Match(only({1} ancestor_name),'Total Assets','Fixed Assets less Accumulated Depreciation','Cash and Cash Equivalents','Current assets','Current Liabilities','Working capital',
'Operating working capital (ex FS)','Current Ratio (ex FS)','Net Worth','Working Capital Loans','Capital Employed','RONW %','ROCE %','Operating ROCE %','WACB %',
'Debt/ Equity','Interest coverage ratio','Debt/ EBITDA (ex FS)')
Thanks for the answer