Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Above() for YTD accumulation not working in server

Hi All,

I had a weird situation where one of the expression is working fine in local but not in server/access point.

My expression is looking for sum of the Sales value with YTD accumulation.

For the month of January, value of sales if 1000 let's say, for February it's 0. If i select February month, it should show 1000. Which is 1000+0=1000.

Dimensions are Month-Year & Country Region cyclic group.

I'm able to achieve this using various ways i.e Rangesum/Above but in server it's showing 0 instead of 1000 for a particular Country.

above(Total(sum({<Month={'<=$(=max([Month]))'}>}SALES)),0)

Thanks in advance.

2 Replies
Not applicable
Author

Any suggestions please?

swuehl @Oleg

Not applicable
Author

Could anyone help on this?

qliktech-admin