Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

set analysis

Hello I would like to have the number of Files who don't have a Docs related (the - ones)

Thank you

FileDocs.PNG

1 Solution

Accepted Solutions

Re: set analysis

May be this

Count(DISTINCT File) - Count(DISTINCT {<Doc = {"*"}>} File)

or

Count(DISTINCT {<File = {"=Len(Trim(Doc)) = 0"}>} File)

3 Replies
jonnieyacoub
Contributor

Re: set analysis

NullCount(Docs) ??

satheshreddy
Contributor III

Re: set analysis

Hi Zied,

try like the bellow.

count({<Docs={''}>}File)

Regards

Sathish

Re: set analysis

May be this

Count(DISTINCT File) - Count(DISTINCT {<Doc = {"*"}>} File)

or

Count(DISTINCT {<File = {"=Len(Trim(Doc)) = 0"}>} File)

Community Browser