topic Re: Sorting of some fields in App Development

Sorting of some fields

Anonymous — Fri, 14 Sep 2018 11:04:21 GMT

Hay everyone,

I am facing problem to sort two columns in my table. Sorting on two different column using two different-2 columns.

How can do this .

Re: Sorting of some fields

YoussefBelloum — Fri, 14 Sep 2018 11:39:41 GMT

Hi,

Columns type ? what kind of sorting you're trying to make ? on what kind of objects ?

you can share some screen shots or sample app if you can

Re: Sorting of some fields

rubenmarin — Fri, 14 Sep 2018 12:17:43 GMT

Hi Akshay, for straight table you can sort just by clicking column name to sort.

In case of pivot tables it can be a bit more complicated: by default, in the sort tab, you can choose how to sort the values, to set some selectable sort you can set each expression to "sort by expression" and use variable or island field to select wich column to sort.

Re: Sorting of some fields

Anonymous — Mon, 17 Sep 2018 04:12:22 GMT

HELLO FRNDS,

I have to sort OUR_BALANCE column using DIVI and GLDV And There_BALANCE column using UNIT and GLDV CODE. I am use set expression

sum({<TDATE={"<=$(=max(TDATE))"}>}OUR_BALANCE)

sum({<TDATE={"<=$(=max(TDATE))"}>}THERE_BALANCE).

Help me to sortout this problem.

Thanks

Re: Sorting of some fields

rubenmarin — Mon, 17 Sep 2018 16:22:43 GMT

Hi Akshay, in a straigh table you only need to click on column titles to change to sort, if you sort by DIVI and GLDV... GLDV ID or GLDV CODE?.

You can sort by expression GLDV CODE in Sort tab, expand the dimension and select sort by expression:

sum({<TDATE={"<=$(=max(TDATE))"}>}THERE_BALANCE).

Re: Sorting of some fields

Anonymous — Tue, 18 Sep 2018 07:04:30 GMT

Hi Ruben, in straight table when i click on filter pane of date field it is automatically sort balance fields so tell me how can i do this using set expression or load script. what options i use too solve this problem.