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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!