topic Re: How to remove duplicate values in If Statement expressions in QlikView

How to remove duplicate values in If Statement expressions

saivina2920 — Fri, 15 Nov 2024 23:23:04 GMT

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

below is the screenshot.

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...???

Re: How to remove duplicate values in If Statement expressions

QFabian — Mon, 04 Jan 2021 12:22:23 GMT

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

Re: How to remove duplicate values in If Statement expressions

saivina2920 — Mon, 04 Jan 2021 16:08:11 GMT

what is alternate way to truncate duplicate EMP_DOC_NO..

Re: How to remove duplicate values in If Statement expressions

saivina2920 — Wed, 06 Jan 2021 06:00:42 GMT

any update.

Re: How to remove duplicate values in If Statement expressions

Chanty4u — Wed, 06 Jan 2021 10:25:23 GMT

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,