Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
iktrayanov
Creator III
Creator III

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])


View solution in original post

15 Replies
Not applicable
Author

Test

Anonymous
Not applicable
Author

Not applicable
Author

Can someone help me pls?

iktrayanov
Creator III
Creator III

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])


iktrayanov
Creator III
Creator III

Attached is an example

Not applicable
Author

thank you so much for your help!

Not applicable
Author

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!

iktrayanov
Creator III
Creator III

This should work.Only one detail I noticed the brackets are missing around [mese cedolini].

Not applicable
Author

Thank you!