Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sarasmonu
New Contributor III

Sort - Month(Date)&'-'&Year(Date)

Hi All,

I am using Month(Date)&'-'&Year(Date) expression in my dimension in bar chart and i want it to be sorted Month and then year wise, Ex-

Jan-13, Feb-13.. and so on.

I see that the expression has been sorted properly but for some reason Oct-2013 and Nov-2013 is getting displayed at the end after Sep-2017.

Please help me get this fixed.

Thanks,

Monu

1 Solution

Accepted Solutions
MVP
MVP

Re: Sort - Month(Date)&'-'&Year(Date)

sort by

max(Date)

6 Replies
aarkay29
Valued Contributor

Re: Sort - Month(Date)&'-'&Year(Date)

Try Sort by Expression Date(Monthstart(Date),'MMM-YYYY')

sarasmonu
New Contributor III

Re: Sort - Month(Date)&'-'&Year(Date)

Thanks ! Makes sense, but did not work.

antoniotiman
Honored Contributor III

Re: Sort - Month(Date)&'-'&Year(Date)

Hi,

why don't use

MonthName(Date)

instead of Month(Date)&'-'&Year(Date) ?

MonthName() is Dual Function.

=MonthName('13/06/2017')

Regards,

Antonio

MVP
MVP

Re: Sort - Month(Date)&'-'&Year(Date)

sort by

max(Date)

aarkay29
Valued Contributor

Re: Sort - Month(Date)&'-'&Year(Date)

Just give a try by using Date(Monthstart(Date),'MMM-YYYY') as Dim and sorting check Numeric ascending/descending

sarasmonu
New Contributor III

Re: Sort - Month(Date)&'-'&Year(Date)

Thanks All for ur response!

Massimo, your suggestion worked. Thank you !

Community Browser