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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Transform if in set Analysis

Count( if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1), employee_id,0))

How can put this in Set analysis ?

Thx,

3 Replies
jvitantonio
Specialist III
Specialist III

Hi try this:

count( {$<date_start = {>=date(vdateNum)}, date_etabl = {>=date(vdateNum), NULL}, date_branch = {>=date(vdateNum), NULL} >} employee_id)

Not applicable
Author

Hi,

You can do this  by using flags.

Make a flag in you script like:

if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1),1,0) as Flag

succes,

Halmar

Not applicable
Author

Thanks !!