Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

P\E set analysis

hi all

in my model, i have an expression as below 

Count({$<ApplicantSubStatus={'A'} ,FromMonthYear= p(MonthYear)> } distinct App_ID)

when selection in the model is 2019 without Month or MonthYear it retrieves the accumulated value 

when selecting  MonthYear or Year value and Month value it retrieves the correct

how can i edit the expression that it will retrive only the correct population for every month and not the accumulated

attached examples 

year month.jpgyear.jpg

advanced thanks

1 Reply
Lauri
Specialist
Specialist

What do your tables and relationships look like? Do you calculate FromMonthYear?