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.