Need help in correcting the formula

[farheenayesha]

Hi,

    Please help me to correct the below formula

Not working:(on server)

(sum(total {1} [Lower_Level_Goal.Goal 2017]) - sum(total {$<[Lower_Level_Goal.Month Id]= {"$(='<=' & max([Lower_Level_Goal.Month Id]))"}>} [Lower_Level_Goal.Total Product Sales Amount]))

/sum({$<[Lower_Level_Goal.Month Id]= {"$(='>' & max([Lower_Level_Goal.Month Id]))"}>} total Aggr(Avg({$<[Lower_Level_Goal.Month Id]= {"$(='>' & max([Lower_Level_Goal.Month Id]))"}>} [Lower_Level_Goal.No of Weeks]),[Lower_Level_Goal.Month]))

The above formula shows values for the first half of the expression but when i write the second half which is in bold, the value becomes blank. I feel the problem is in the set analysis expression but i am not understanding the problem.

I have used the same expression on my Qliksense Desktop and all the expression are working perfectly fine. but on the server it is not working. Please find the expression which i have used on my desktop application.

Working:(on desktop)

=((Sum(TOTAL {1}Goal) - Sum(TOTAL {<Month = {"<=$(=Max(Month))"}>} Sales))

/Sum({<Month = {">$(=Max(Month))"}>}TOTAL Aggr(Avg({<Month = {">$(=Max(Month))"}>} [No of Weeks]), Month)))

Please let me know if i am missing anything..

Thanks in advance.