Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I am not really sure if I understand your question but too get the sum of [retr.mese/importo] for example
you can use something like
Sum({$<[anno cedolini] = {2012},mese cedolini= {'6','7','8','9'}>}[retr.mese/importo])
Test
Can someone help me pls?
I am not really sure if I understand your question but too get the sum of [retr.mese/importo] for example
you can use something like
Sum({$<[anno cedolini] = {2012},mese cedolini= {'6','7','8','9'}>}[retr.mese/importo])
Attached is an example
thank you so much for your help!
Hi! If I want to sum fields from 11/2012 to 03/2013, I can use something like:
Sum({$<[anno cedolini] = {2012},mese cedolini= {'11','12'}>}[retr.mese/importo] + [retr.mese/importo] +[retr.mese/contributi] + [retr.mese/inail] + [lav.strao/importo] +[lav.strao/contributi] + [lav.strao/inail]) +
Sum({$<[anno cedolini] = {2013},mese cedolini= {'1','2','3'}>}[retr.mese/importo] + [retr.mese/importo] +[retr.mese/contributi] + [retr.mese/inail] + [lav.strao/importo] +[lav.strao/contributi] + [lav.strao/inail])
Thanking you in advance for your help in this matter, I look forward to your reply!
This should work.Only one detail I noticed the brackets are missing around [mese cedolini].
Thank you!