Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

How to remove duplicate values in If Statement expressions

i have the below records. i just want to remove the duplicate values of EMP_DOC_NO.

below is the screenshot.

Duplicate Remove - 04JAN2021-1.png

DIM-1: 

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE), EMP_RESIGN_DATE), if(not IsNull(EMP_RELIEVE_DATE), EMP_RESIGN_DATE))

DIM-2:

=EMP_DOC_NO

Expr-1: (Relieving_Date)

=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]), Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull([EMP_RELIEVE_DATE]), EMP_RELIEVE_DATE))

Expr-2: (1-10days)

If([Relieving_Date]>=vCalDate10 And [Relieving_Date]<=vToday, 1,0)

Expr-3: (10-30 days)

If([Relieving_Date]>=vCalDate30 And [Relieving_Date]<=vCalDate10, 1,0)

How to remove the duplicate values  in the above expressions...???

 

 

Labels (1)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Hi ,

this is because of    emp reg date or relieving date  

as there is 3 dates for   EMP-004   thats y its shwoing duplicate in the data,

View solution in original post

4 Replies
QFabian
Specialist III
Specialist III

Hi @saivina2920 , check that you have another fields in that table : Emp Reg Date Relieving_Date, and they have diferent values, so, the value for EMP_DOC_NO, its going to be repeated because of the relation with the others fields

QFabian
saivina2920
Creator
Creator
Author

what is alternate way to truncate duplicate EMP_DOC_NO..

saivina2920
Creator
Creator
Author

any update.

Chanty4u
MVP
MVP

Hi ,

this is because of    emp reg date or relieving date  

as there is 3 dates for   EMP-004   thats y its shwoing duplicate in the data,