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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is wrong with my equation? or set analysis?

I need to get a nuber of days between two dates and compare it if it greater than 0 and less or equal to 7.

So, I have come up with the equation below, but it said "error in set modifier expression."

what is wrong with that?

Count({<Num(SERVICE_ACT_TERM_DATE-SERVICE_DATE_START)={">0<=7"}>}PERSONID)

12 Replies
Not applicable
Author

Hi, Jagan,

I would like to delete or close this thread as you requested. However, it comes out that I am not authorized to delete this post. How can I close it?

Anonymous
Not applicable
Author

Mark the most useful answer as "Correct"

jagan
Partner - Champion III
Partner - Champion III

Hi,

AS msolomov suggested please give correct answer to the most useful post which helps you in getting the solution.

Regards,

Jagan.