Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - Specialist

Value changes when i select latest month

This is my expression which shows the correct number for last month if no selections are made , or if any selection is made it still works , except  now when i select the latest month .

I noticed when i select the latest month the number changes slightly due to the KREF numbers not availble for the  latest month , but dont understand why its affecting the previous months number which is the expression below 

Sum( Aggr(Sum({<SPERIOD={$(y_Speriod-1)},FIN_YR_NO=, MTH_SHORT_DESC=>}DISTINCT no_rejection),Kref)

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post and see if that helps you resolve the why on this one, sorry I do not have something better for you:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.