Count distinct and set analysis

[FernandaNava]

Hello,

I'm trying to count the distinct ID's for a field that have a flag=1. I have tried:

count(DISTINCT {<flagmanual={'1'}>} studyuid)

and solutions posted for these questions:

https://community.qlik.com/t5/QlikView-App-Development/Count-distinct-in-Set-Analysis/td-p/602254

https://community.qlik.com/t5/QlikView-App-Development/Count-distinct-in-Set-Analysis/td-p/602254z

But I can't seem to get it to work. I tried using '1' to not have my measure affected by selections but the result doesn't change.

I appreciate your help

[Lisa_P]

is the data related ?

[lironbaram]

hi 

one thing , you can try to write the 

count(DISTINCT {<flagmanual={1}>} studyuid)

but to really help you , can you describe if both fields are in the same table , or connected somehow

[FernandaNava]

They are fields in the same table. If pick my flag from a selection pane the data is in fact affected. I even tried inserting the set expression from current selection via the wizard but it's still not working. 

[nicu1996]

$ is the default state.

1 is the alternate state.

Try:

COUNT(DISTINCT {1<flagmanual={'1'}>} studyuid)

[Sameer9585]

try this?

count({<flagmanual={1}>} distinct studyuid)