Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Edited for clarity. Had something that did not make sense in text.
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
That does not solve it unfortunately.
Is there something that can be done in the load script? Thank you for your help.
Can you share your app or sample data? Are you using Qlik Sense or QlikView?
Hi,
on the sorting expression, disable everything and enable only expression and put this on ascending:
=mid(Quarter_field,'2','2')
See if below sample represents your need
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.
May be, Sort by expression:
Expression:
=Min(TOTAL Aggr(Sum(Sales),QuarterYear))
If you cleared the issue, post the solution.