Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Luben
Creator
Creator

Set analysis

Hello I need help converting the below IF statement to Set analysis;

COUNT(
DISTINCT IF(
Folder_Open_Date >=vstart_date AND
Folder_Open_Date <=vend_date AND
[Status]<>"V" AND [Status]<>"Void"

,[Claim]

,NULL
)

Thanks in Advance. 

11 Replies
JGMDataAnalysis
Creator III
Creator III

In addition to what @Digvijay_Singh asks you,
Could you share us the definition in script of the field [Folder_Open_Date] or a screenshot of what it looks like used in a chart?

Luben
Creator
Creator
Author

it's says ok at the bottom of the Edit expression. 

Luben_0-1634825806094.png

that is the above date that show up 

 

 

SET DateFormat= 'YYYY-MM-DD'; this  my date format