Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Accumulate value from the beginning of year to the current month in calculation

Hi,

I want to calculate 

Calc1 = Billed Revenue in Jun (current) till  Jan / Total Billed Revenue

 

I do to like this, but it only show the Jun only not from the beginning of year

Sum({[SPM Year]={'$(vMaxYear)'},[SPM Est Close Month] = {'$(vMaxMonth2)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Accumulate value from the beginning of year to the current month in calculation

Thank you for the formula.

But I have to change the month to be in Num to use the <=.

 

Sum({[SPM Year]={'$(vMaxYear)'},[SPM Num Month]= {'<=$(vMonthNum)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

 

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Accumulate value from the beginning of year to the current month in calculation

Try this:

Sum({[SPM Year]={'$(vMaxYear)'},[SPM Est Close Month] = {"<=$(vMaxMonth2)"}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

Highlighted
Partner
Partner

Re: Accumulate value from the beginning of year to the current month in calculation

Thank you for the formula.

But I have to change the month to be in Num to use the <=.

 

Sum({[SPM Year]={'$(vMaxYear)'},[SPM Num Month]= {'<=$(vMonthNum)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

 

View solution in original post