How to sort quarters(Q1-2013,Q2-2013,so on) as per year in line chart or bar chart?

[Anonymous]

I'm new to Qliksense, still learning lot of new things.

I have OrderDate as date field in my data. (ex-10/1/2014, 30/2/2013)

I have total 3 years data 2013,2014,2015

I created 3 master items to have Month, Year, Quarter as I needed to use them for different charts.

Now i have made a bar chart using sales as my y-axis(measure) and quarters as my x-axis(dimension)

Now i can see respective quarters with years in my sheet but they are not sorted according to year.

its like Q4-2013, Q2-2014 and so on.

I want to sort quarters by their respective years.(Q1-2013,Q2-2013 and so on)

I looked up other blogs having use Dual,match functions and some using if and some using inline coding in load script.

Please help me i will really appreciate that.

PFA for your reference.

[devarasu07]

Hi,

have you tried to Sort by Date (like Desc or Ascending order)?. Thanks

also you try to add below script in your master calendar

'Q' & Ceil(Month(CalDate)/3)&'-'&Year(CalDate) as QuarterYear,

then use this field in Dimension and Sort by  QuarterYear,

Refer to the sample attached,

Thanks

Deva

[balabhaskarqlik]

May be, Sort by expression:

Expression:

=Min(TOTAL Aggr(Sum(Sales),QuarterYear))