Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Expression how to modify so it will compute previous month amount ?

Hi All

Below expression working fine. as it display max month amount.

money(

FABS(

sum({$<year = {$(=max(year))}, Month = {"<=$(=max({<year={$(=max(year))}>} Month))>$(=max({<year={$(=max(year))}>} Month)-1)"}>}   Amount/1000/$(ColumnDim98))

)

, $(vMoneyFormatK_GL))

I like to modify this expression to display previous month amount instead of current month amount. may i know how where should i make changes ? See my enclsoed QV Doc in my next post.

Paul

1 Solution

Accepted Solutions
Not applicable

Re: Set Expression how to modify so it will compute previous month amount ?

use this function: =num(AddMonths(vMaximumDate,-1))

where vMaximumDate is your currect date Year and month.

2 Replies
Not applicable

Re: Set Expression how to modify so it will compute previous month amount ?

Enclosed my QV Doc here.

make 204 dsiplay as 103.png

Not applicable

Re: Set Expression how to modify so it will compute previous month amount ?

use this function: =num(AddMonths(vMaximumDate,-1))

where vMaximumDate is your currect date Year and month.

Community Browser