Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
Showing results for 
Search instead for 
Did you mean: 

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

Hi ,

     Try this

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


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.