Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This may be a silly question , but on the expression tab of you object, do you have "no accumulation" selected?
hi ,
it is happening in QlikSense so,, i dont know if there is an option to check/uncheck this option
oh, this is the Qlikview forum. May want to try asking it in here:
i think Creating Analytics is a common forum for all qlik users
as the expression syntax is the same..
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.