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 - in 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

any ideas ?

advanced thanks 

 

Labels (3)
5 Replies
olivetwist
Creator
Creator

This may be a silly question , but on the expression tab of you object, do you have "no accumulation" selected?

 

ilanbaruch
Specialist
Specialist
Author

hi ,

it is happening in QlikSense so,, i dont know if there is an option to check/uncheck this option

olivetwist
Creator
Creator

oh, this is the Qlikview forum. May want to try asking it in here:


https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

ilanbaruch
Specialist
Specialist
Author

i think Creating Analytics is a common forum for all qlik users

as the expression syntax is the same..

olivetwist
Creator
Creator

I agree, but in QlikView there is an ability to choose accumulation or not. If that's not available in Qlik, i thought the forums more dedicated to that platform would have individuals looking at it with better solutions.