Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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