Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

How to modify expression from YTD amount to total accumulated amount ?

HI All,


my below expression working fine :-


Money(

Sum(Aggr(SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))

,

$(vMoneyFormatK))


I like to modify the below expression instead of compute the YTD amount , i like to change to accumulation :-


I have try this work , but it only give revenue amount , i need it to be dynamic:-


(Sum({<rEVENUE={rEVENUE}>}Amount))


I have try the below it does not work. ( As it return null value)


(Sum({<$(ColumnDim108)={$(ColumnDim108)}>}Amount))


Hope some one can help me.


Paul Yeo

1 Reply
paulyeo11
Valued Contributor II

Re: How to modify expression from YTD amount to total accumulated amount ?

ENclosed my QVW

Community Browser