Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
or
textCount(distinct {<Doc_ID-={'n/a', 'tbd'}>} Doc_ID)
for AND
textCount(distinct {<Doc_ID-={'n/a',} and Doc_ID-={'tbd'}>} Doc_ID)
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.