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

# 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 filiale matricola  dipendente anno cedolini mese cedolini retr.mese/quantita' retr.mese/importo retr.mese/contributi retr.mese/inail lav.strao/quantita' lav.strao/importo lav.strao/contributi lav.strao/inail 4 1 199 2012 1 78 857,94 255,11 15,6 5,5 5,35 1,66 0,1 4 1 199 2012 2 39,5 532,47 154,1 9,68 6,8 6,62 2,05 0,12 4 1 199 2012 3 83 839,75 250,07 17,82 10 9,82 3,04 0,21 4 1 199 2012 4 81,5 893,39 265,59 18,94 11,5 11,29 3,5 0,24 4 1 199 2012 5 71,5 942,88 281,88 20,01 16 15,71 4,87 0,33 4 1 199 2012 6 85 864,31 245,35 18,33 10,5 64,33 19,93 1,36 4 1 199 2012 7 49 715,88 208,95 15,17 5 4,91 1,52 0,1 4 1 199 2012 8 90 977,26 292,63 20,72 10,5 10,31 3,19 0,22 4 1 199 2012 9 89 892,04 266 18,91 10 9,97 3,09 0,21 4 1 199 2012 10 113,5 1149,58 345,58 24,39 10 9,97 3,09 0,21 4 1 199 2012 11 105 1087,74 326,61 23,08 0 0 0 0 4 1 199 2012 12 63,6 1071,45 307,95 22,73 35,5 188,88 58,52 4,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