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