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

    Second MaxString

    Prashant Kumar

      Hi,

       

      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

       

      Sum({$<Quarter={"$(=MaxString(Quarter))"}>}Value)

       

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

       

      Thanks in Advance!