Help with sorting quarters on X-Axis in order by date administered

[Anonymous]

Hello everyone,

I have created a line graph that seems to be sorting the quarters by grouping them by quarter...so quarter 1 together, quarter 2 together, quarter 3 together.

How do I get it to where they are in order of administration? So Q1 2016, Q2 2016, etc...

[Anonymous]

Edited for clarity. Had something that did not make sense in text.

[vvira1316]

If you have numeric values for each of those quarters then you may want to sort based on Numeric values of them.

Then you will see in calendar sequence

[Anonymous]

That does not solve it unfortunately.

Is there something that can be done in the load script? Thank you for your help. 

[vvira1316]

Can you share your app or sample data? Are you using Qlik Sense or QlikView?

[YoussefBelloum]

Hi,

on the sorting expression, disable everything and enable only expression and put this on ascending:

=mid(Quarter_field,'2','2')

[vvira1316]

See if below sample represents your need

[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.

[balabhaskarqlik]

May be, Sort by expression:

Expression:

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

[balabhaskarqlik]

If you cleared the issue, post the solution.