Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?