0 Replies Latest reply: Nov 20, 2017 12:25 AM by Divyanshi Bansal RSS

    Subtracting one of the Quarter among multiples selected Quarter in Qliksense

    Divyanshi Bansal



      I applied a logic in which if I select multiple Quarter from Quarter filter i.e. say Q1 & Q2 of year 2017 then it should return the value

      Q4 of 2016 year and Q1 of 2017(by subtracting one in previous category).


      By using Quarters={$(=Concat(Distinct 'Q' & (( mid(Quarters,2))-1),','))},

      it is giving subtract by one of selected Quarter.


      This works perfectly in case of one Year i.e. 2017 i.e. if I select Q2 , Q3 it is giving Q1 and Q2 respectively which is correct.


      But it fails in computing previous of Q1 which should be Q4 of Previous Year.


      Kindly help.