7 Replies Latest reply: Feb 27, 2017 9:22 PM by Prashant Kumar RSS

    Second MaxString



      I am new to Qlik Sense and would be very grateful if someone could help me out with this problem.


      I have a field called Quarter which has the following values


      FY1516-Quarter 2

      FY1516-Quarter 3

      FY1516-Quarter 4

      FY1617-Quarter 1

      FY1617-Quarter 2


      I want to find the sum of another field called value for the highest quarter and the second highest quarter selected i.e. if the last 3 are selected in the above list, I should get the sum of values for FY1617-Quarter 2 and FY1617- Quarter 1.


      I have got the value for FY1617-Quarter 2 with the following




      However, I am not sure how to obtain the value for FY1617-Quarter 1. Can someone please help me out?


      Thanks in Advance!