0 Replies Latest reply: Dec 22, 2013 1:46 PM by Andrea Rossi RSS

    Date  - set Analysis

      Hi,

       

      I'm a beginner to Qlikview.

      I'm trying to write an expression for a graphic to sum these fields [retr.mese/importo], [retr.mese/contributi], [retr.mese/inail], [lav.strao/importo],[lav.strao/contributi], [lav.strao/inail] from 06/2012 to 09/2012.

      Below an example:

       

      codice
        azienda
      codice filialematricola
        dipendente
      anno cedolinimese cedoliniretr.mese/quantita'retr.mese/importoretr.mese/contributiretr.mese/inaillav.strao/quantita'lav.strao/importolav.strao/contributilav.strao/inail
      411992012178857,94255,1115,65,55,351,660,1
      411992012239,5532,47154,19,686,86,622,050,12
      411992012383839,75250,0717,82109,823,040,21
      411992012481,5893,39265,5918,9411,511,293,50,24
      411992012571,5942,88281,8820,011615,714,870,33
      411992012685864,31245,3518,3310,564,3319,931,36
      411992012749715,88208,9515,1754,911,520,1
      411992012890977,26292,6320,7210,510,313,190,22
      411992012989892,0426618,91109,973,090,21
      41199201210113,51149,58345,5824,39109,973,090,21
      411992012111051087,74326,6123,080000
      4119920121263,61071,45307,9522,7335,5188,8858,524,01

       

      And then how can I calculate the difference between the sum of the fields [retr.mese/importo], [retr.mese/contributi], [retr.mese/inail], [lav.strao/importo],[lav.strao/contributi], [lav.strao/inail] from 06/2012 to 09/2012 and from 06/2013 to 09/2013?

      Any suggestions greatly appreciated.

      Regards,

      Andrea