Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jtrillori
Partner - Contributor
Partner - Contributor

sum next month

hi

i have a field called Month

i need sum then next month that the current selection,

sum( {$<Mes = {'(Mes+1)'}>} ImporteBudget)/1000

doesn´t work

please help

thanks and regards

2 Replies
Not applicable

Hi ,

     Try this

sum( {<Mes = {'$(Mes+1)'}>}

//Yusuf

Not applicable

Try Chart Inter-Record Expressions. You can look them up with the Help function.

Below(sum(ImporteBudget))/1000 will probably work.


If your chart is a graph, rather than a table, consider changing it to a table to verify your calculations, then turning it back to a graph when you have finished as a general tip.