How to use AND or OR operators in distinct count function

[7UL13N]

Hi community,

I am rather new to Qlik Sense and I am facing difficulties in counting distinct document IDs under the condition that they are neither "n/a" nor "tbd".

I tried this:

textCount(distinct {<Doc_ID-={"n/a"},[Doc_ID]-={"tbd"}>} Doc_ID)

But as you can guess I was not successful. If I keep only one of the tests result is 29, but if I add both result becomes 30 instead of the expected 28.

 Any help welcome!

[dplr-rn]

change it to this
textCount(distinct {<Doc_ID-={'n/a', 'tbd'}>} Doc_ID)

[Channa]

or

textCount(distinct {<Doc_ID-={'n/a', 'tbd'}>} Doc_ID)

for AND

textCount(distinct {<Doc_ID-={'n/a',} and Doc_ID-={'tbd'}>} Doc_ID)

[nagaiank]

Please see the following post in Qlik forum for Set Analysis operators

https://community.qlik.com/t5/QlikView-Documents/Operator-in-Set-Analysis/ta-p/1479010

Hope this helps.