Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
jtrillori
Contributor
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.