Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

OR CONDITION in SET ANALYSIS EXPRESSION

Hi,

I have an expression - Count(DISTINCT If((DOL1='01/01/1900' or DOL1 >= Date(Today(),'DD/MM/YYYY')),EmpCode))

Output is coming correct - 4719

When I am using  SET ANALYSIS - Output is wrong - 4701.

Count({<[DOL1]={'01/01/1900'}>+<[DOL1]={">=$(=Date(Today(), 'DD/MM/YYYY'))"}>} Distinct [EmpCode])

Can anyone correct the same. Please find the attached xls for data.

Thanks.

 

Labels (1)
1 Solution

Accepted Solutions
TiagoCardoso
Creator II
Creator II

Hi, try this:

 

Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)

View solution in original post

1 Reply
TiagoCardoso
Creator II
Creator II

Hi, try this:

 

Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)