topic Help with expression in QlikView

Help with expression

Tue, 18 Mar 2014 13:05:15 GMT

I have the following expression

=(Sum({<CalendarDate={'>=$(=AddMonths((MonthStart(Today())),-12))<=$(=mONTHEND(AddMonths((Monthend(Today())),-1)))'}>} AccountBalance)*-1)

and it works well with getting the previous 12 months., But I need to divide that expression with basically the same formula, but I only want to see when 'NewFRXTitle={Sales}' the total of that.

I am trying to get percentage of sales, here is my working formula, but it won't do previous 12 months, I am trying to get the formula below to work with the formula above for the previous 12 months.

Sum(AccountBalance)/Sum({<NewFRXTitle={Sales}>}total <[CalendarYear]> AccountBalance)

Please don't send any files as I only have qlikview personal edition. any help much appreciated

Re: Help with expression

Gysbert_Wassenaar — Tue, 18 Mar 2014 13:22:20 GMT

This?

(Sum({<CalendarDate={'>=$(=AddMonths((MonthStart(Today())),-12))<=$(=monthend(AddMonths((Monthend(Today())),-1)))'}>} AccountBalance)*-1)

(Sum({<NewFRXTitle={Sales}, CalendarDate={'>=$(=AddMonths((MonthStart(Today())),-12))<=$(=monthend(AddMonths((Monthend(Today())),-1)))'}>} AccountBalance)*-1)

Re: Help with expression

Tue, 18 Mar 2014 13:25:40 GMT

Works perfect,thanks!