Sort the month based on FinancialMonth

[#1]

Dear All,

i want to sort the month based on financialmonth.(April,May,June ,,,,,,,,,,,,,,,,,,,,,,,,March)

i am able to sort it

.but on selection the selected month is moving to last right in the list box.

i don't want to move that month to last of the listbox.

find the attached sample.

Thanks,

Mukram.

[IAMDV]

Hi Mukram,

Please see attached. You need to add Sort by state as "Ascending". So that your selections won't change the position and still you can sort by your FinancialMonth.

I hope this helps!

Cheers,

DV

www.QlikShare.com

[#3]

Dear Deepak.

Thanks for your reply.

when i did the sort state by 'Ascending' the selected Month is coming as first and order of month is changing.

Thanks,

Mukram.

[IAMDV · Accepted solution]

Hi Mukram,

Sorry I misunderstood your requirement. You need to use this expression in sorting...

=only({1} FinancialMonth)

Attaching the same.

I hope this helps!

Cheers,

DV

www.QlikShare.com

[#5]

Dear Deepak.

Thank you.

it's working fine.

Thanks,

Mukram.