Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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

Labels (1)