Qlik Community

Ask a Question

Qlik Sense Deployment & Management

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

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

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

May be this

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

or

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

View solution in original post

3 Replies
Creator
Creator

NullCount(Docs) ??

Creator III
Creator III

Hi Zied,

try like the bellow.

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

Regards

Sathish

May be this

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

or

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

View solution in original post