topic Re: How to Sort master item and value in App Development

How to Sort master item and value

wangxusq — Sat, 05 May 2018 11:24:47 GMT

Hi All,

In Master Item:

Two question:

1.If we can not rename them ,I want to Sort :Year->Month

2.For Month field, I want to sort from Jan to Dec,not A-Z.

Any idea,thanks.

Re: How to Sort master item and value

bhaskar_sm — Sun, 06 May 2018 14:25:00 GMT

Hi,

You can sort Month by using Pick Match Functions(PFB) in Sortby Expresstion under the listbox property and then you can add this to master item.

pick(Match(YourMonthField,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),1,2,3,4,5,6,7,8,9,10,11,12)

or you can achieve the same thing in backend- master calender using dual function PFB.

Dual(YourMonthField, YourMonthNumber)

I,e Dual(CalenderMonth, CMonth)

where Cmonth is Month(TempDate) as CMonth,

in a same way you can sort the year as well.

if you found this helpful, please mark helpful or correct

Regards,

Bhasker Kumar

Re: How to Sort master item and value

wangxusq — Mon, 07 May 2018 03:02:09 GMT

Hi ,

Thanks for your response. I want to Add master-item(Dimension),because I need to use it by selection bar.

For the first solution: field shows number not Jan、Feb and so on.My client hope show Jan、Feb…

For the second solution,when I select Month field, I do not want to display YourMonthNumber on he selection bar.

Any Idea?

What's more, can I sort :Year-->Month. Year is at the first place. Of course maybe I have many filters, I want to sort them according to my idea.

Re: How to Sort master item and value

jheasley — Mon, 07 May 2018 18:39:24 GMT

Try sorting the master item by its related date field using the custom expression then min(Date([DateField])) ascending or descending.

Re: How to Sort master item and value

wangxusq — Mon, 21 May 2018 08:53:50 GMT

Hi ,

Thanks for your response. I need to create master-item(dimension). I find when I use a expression in master item dimension. The selection bar will not display it. This is a bug?

Re: How to Sort master item and value

RAMK — Thu, 02 Apr 2020 14:06:15 GMT

hello,

i came across the same issue, untick chart suggestions and you will see it.

Thanks.