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

      Hi,

       

      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.