3 Replies Latest reply: Aug 7, 2017 12:09 PM by Pankaj Thakur RSS

    How to get maximum Year from column having year (as int) for a particular condition ( set analysis) for particular set analysis

    Deepali Gadge

      Hi,

       

      I am new to qlik sense and need an expert help please.

       

      I have a sample data as follows:

       

         

      As Of DateAccount NumberLoanPurposeTrend_YearOriginal Balance
      12/31/2016021000001987174400
      12/31/201602900000198899900
      12/31/2016024500000198797000
      12/31/20160271000001986130000
      1/31/201707000001987180000
      1/31/2017021000001987174400
      1/31/201702900000198899900
      1/31/2017026600000198678600
      3/31/201707000001987180000
      3/31/2017021000001987174400
      3/31/201702900000198899900
      3/31/2017021700000198699000
      5/31/2017021000001987174400
      5/31/201702900000198899900
      5/31/2017024500000198797000
      5/31/20170271000001986130000
      6/30/2017021000001987174400
      6/30/201702900000198899900
      6/30/2017024500000198797000
      6/30/20170271000001986130000

       

       

       

      I want original balance for max " Ltrend Year"  when particular "as of date" is selected.

       

      Wanted to select max "LTrend Year" as my dimension for visualization. what is an expression for the same. Can someone please help with an expression.

       

      Thanks.