topic Re: sum next month in QlikView

sum next month

jtrillori — Tue, 16 Apr 2013 14:03:07 GMT

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

Re: sum next month

Tue, 16 Apr 2013 14:17:48 GMT

Hi ,

Try this

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

//Yusuf

Re: sum next month

Tue, 16 Apr 2013 15:13:33 GMT

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.