topic Expression to compare two fields in QlikView

Expression to compare two fields

Mon, 18 Jul 2011 07:30:04 GMT

Hi,

Please i have a question

i have this table

Date	New Date	Field1	Field2
2/1/2010	?	1	A
3/1/2010	?	1	B
4/1/2010	?	1	A
5/1/2010	?	2	B
6/1/2010	?	2	A
7/1/2010	?	1	B

i want an expression for the field New Date based on

if Field2 has a repeated value and the corresponding values in Field1 are equal

like the case 1,A and 1,A

so i want the New Date face these 2 records to be the minimum date of both

this is the final result i want

Date	New Date	Field1	Field2
2/1/2010	2/1/2010	1	A
3/1/2010	3/1/2010	1	B
4/1/2010	2/1/2010	1	A
5/1/2010	5/1/2010	2	B
6/1/2010	6/1/2010	2	A
7/1/2010	3/1/2010	1	B

Thanks in Advance

Re: Expression to compare two fields

lironbaram — Mon, 18 Jul 2011 07:50:59 GMT

hei attach is an example

Re: Expression to compare two fields

Mon, 18 Jul 2011 08:14:08 GMT

Thanks so much for your help

but what if i want this case

Date	New Date	Field1	Field2
2/1/2010	?	1	A
3/1/2010	?	1	B
4/1/2010	?	1	Ax
5/1/2010	?	2	B
6/1/2010	?	2	A
7/1/2010	?	1	By

and i want to compare A after removing x from it with A in the other record and if they are equal to apply the last situation,the same also for B after removing y from it to compare it with B

i.e the final result will also be

Date	New Date	Field1	Field2
2/1/2010	2/1/2010	1	A
3/1/2010	3/1/2010	1	B
4/1/2010	2/1/2010	1	Ax
5/1/2010	5/1/2010	2	B
6/1/2010	6/1/2010	2	A
7/1/2010	3/1/2010	1	By

Re: Expression to compare two fields

lironbaram — Mon, 18 Jul 2011 08:22:15 GMT

then i would recomend you to go and create a new field in the load script

that will be something like

left(Field2,1) as Field3

then use Field 3 in the expression

Re: Expression to compare two fields

Mon, 18 Jul 2011 09:13:18 GMT

Thanks so much for your help