7 Replies Latest reply: Feb 12, 2018 2:21 PM by Sunny Talwar RSS

    Sorting By Expression (Months of Fiscal Year)

    William Christensen

      I was attempting to reorder the months based on the start of the fiscal year. My first attempt at this was adding “Mod((Month(Tbl01_Date)+3), 12)” to a custom sort expression as shown below in Line Chart 2 below. I would like to know why this didn’t sort as expected. I eventually was able to achieve the desired sort order with the expression “Only({1}Mod((Month(Tbl01_Date)+3), 12))” as shown in Line Chart 1. I would like to know why I had to use a set analysis expression to make this work. I would appreciate any help you can provide in understanding this strange behavior.

      StrangeSortBehavior.png

      Qlik Sense 3.2