2 Replies Latest reply: Dec 8, 2017 1:17 AM by Petter Skjolden RSS

    set analysis qlik sense

    franco monti

      Hi,

      why not select correcty this

       

      Sum({<AnnoMese_Rata={'>$(Anno_Scadenza+$(vMese_Rata))'}>}Premio)

       

      $(vMese_Rata) is variable

       

      Movimenti_0:

      LOAD * INLINE [

      id,Frazionamento,Mese_Rata,Mese_Scadenza,AnnoMese_Rata, Nro_Polizza,Seq,Premio,data_scadenza

      3,Q,5,5,201005,100,1,1350,10/05/2010

      2,Q,9,5,201009,100,2,1350,10/05/2010

      1,Q,1,5,201101,100,3,1350,10/05/2010

      5,Q,10,10,201310,155,1,2350,21/10/2013

      6,Q,2,10,201402,155,2,2350,21/10/2013

      4,Q,6,10,201406,155,3,2350,21/10/2013

      9,Q,9,9,201609,200,1,450,02/09/2016

      8,Q,1,9,201701,200,2,450,02/09/2016

      7,Q,5,9,201705,200,3,450,02/09/2016

      12,Q,2,2,201602,150,1,900,28/02/2016

      10,Q,6,2,201606,150,2,900,28/02/2016

      11,Q,10,2,201610,150,3,900,28/02/2016

      14,Q,1,1,201501,250,1,1500,15/01/2015

      13,Q,5,1,201505,250,2,1500,15/01/2015

      15,Q,9,1,201509,250,3,1500,15/01/2015

      16,Q,6,6,200206,350,1,4350,21/06/2002

      17,Q,10,6,200210,350,2,4350,21/06/2002

      18,Q,2,6,200302,350,3,4350,21/06/2002

      ];

       

      Movimenti:

      NoConcatenate

      load

      id,

      Frazionamento,

      num(AnnoMese_Rata) as AnnoMese_Rata,

      num(Mese_Rata) as Mese_Rata,

      num(Mese_Scadenza) as Mese_Scadenza,

      Nro_Polizza,

      Seq,

      Premio,

      data_scadenza,

      num(year(data_scadenza),'0000')*100 as Anno_Scadenza

      Resident Movimenti_0;

       

      drop Table Movimenti_0;

       

      Thanks

       

      Franco