Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

set analysis - sum from the beginning of the month

i am trying to create a column that contain sum of a field from the beginning of the month until today.

for example, if today is october 6th, i want it to sum from october 1st until october 6th.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: set analysis - sum from the beginning of the month

Try: sum({<MyDate ={'>=$(=date(monthstart(today())))<=$(=date(today()))'}>} MyAmount)


talk is cheap, supply exceeds demand
4 Replies

Re: set analysis - sum from the beginning of the month

Mor


Try     =Sum({<[DateField] ={">=$(=monthstart(today()))<=$(=date(today()))"}>} [ValueField])


Best Regards,     Bill

Not applicable

Re: set analysis - sum from the beginning of the month

Hi,

Try this.

Sum({<vDate= {'>=$(=MonthStart(Today()))'}>} vSales)

MVP & Luminary
MVP & Luminary

Re: set analysis - sum from the beginning of the month

Try: sum({<MyDate ={'>=$(=date(monthstart(today())))<=$(=date(today()))'}>} MyAmount)


talk is cheap, supply exceeds demand
Not applicable

Re: set analysis - sum from the beginning of the month

Hi,

PFA Qlikview and Excel,

Hope it will helps you