Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
May be, Sort by expression:
Expression:
=Min(TOTAL Aggr(Sum(Sales),QuarterYear))