Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Check field equal and dont show result in other field

Hello Everyone !

I have this table:

Field 1Field 2
Ax
Ax
Ay
By
By

And i want create (in script editor) a table like this:

Field 1Field 2
Ax
Ax
A
By
By

Remove the value in the third row of the field 2 !! Please Help me ! Thank you

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Check field equal and dont show result in other field

Not sure why are you doing it, if you just want to remove value, you can do as -

T1:

Load * inline [

Field 1, Field 2

A, x

A, x

A, y

B, y

B, y ];

NoConcatenate

Final:

Load [Field 1],

  If([Field 1]='A' and [Field 2]='y','',[Field 2]) as [Field 2]

Resident T1;

Drop table T1;

6 Replies
jonas_rezende
Valued Contributor

Re: Check field equal and dont show result in other field

Hi, Joao Ribeiro.

What is the rule to keep and remove?

Hope this helps!

Digvijay_Singh
Honored Contributor III

Re: Check field equal and dont show result in other field

Not sure why are you doing it, if you just want to remove value, you can do as -

T1:

Load * inline [

Field 1, Field 2

A, x

A, x

A, y

B, y

B, y ];

NoConcatenate

Final:

Load [Field 1],

  If([Field 1]='A' and [Field 2]='y','',[Field 2]) as [Field 2]

Resident T1;

Drop table T1;

Re: Check field equal and dont show result in other field

Do you mean, You want to keep as Repeated rows also or what. this seems not a make sense to do. Can you describe more

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: Check field equal and dont show result in other field

Thank you All !!

Not applicable

Re: Check field equal and dont show result in other field

Thank you! it work's with numbers, but not work with dates...

do you know why ?!

Digvijay_Singh
Honored Contributor III

Re: Check field equal and dont show result in other field

May be some formatting issue while matching, as dates are stored as nos as well as text, can u share small sample data, I will make it work probably.