Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor

sum next month


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

Re: sum next month

Hi ,

     Try this

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


Not applicable

Re: sum next month

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.

Community Browser