topic Re: p - in set analysis in App Development

p - in set analysis

ilanbaruch — Sat, 16 Nov 2024 20:28:40 GMT

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

any ideas ?

advanced thanks

Re: p - in set analysis

olivetwist — Thu, 11 Jul 2019 12:33:29 GMT

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

Re: p - in set analysis

ilanbaruch — Thu, 11 Jul 2019 12:48:58 GMT

hi ,

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

Re: p - in set analysis

olivetwist — Thu, 11 Jul 2019 12:52:45 GMT

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

Re: p - in set analysis

ilanbaruch — Thu, 11 Jul 2019 14:34:01 GMT

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

as the expression syntax is the same..

Re: p - in set analysis

olivetwist — Thu, 11 Jul 2019 14:39:04 GMT

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.