Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try: sum({<MyDate ={'>=$(=date(monthstart(today())))<=$(=date(today()))'}>} MyAmount)
Mor
Try =Sum({<[DateField] ={">=$(=monthstart(today()))<=$(=date(today()))"}>} [ValueField])
Best Regards, Bill
Hi,
Try this.
Sum({<vDate= {'>=$(=MonthStart(Today()))'}>} vSales)
Try: sum({<MyDate ={'>=$(=date(monthstart(today())))<=$(=date(today()))'}>} MyAmount)
Hi,
PFA Qlikview and Excel,
Hope it will helps you