topic Re: need expression in QlikView

need expression

Mon, 08 Oct 2012 19:32:15 GMT

Need Help:

suppose we have two months

JANUARY FEBURARY

1 1

2 2

3 3

4 4

having the id's i want to to compare the two months and as a result i want the new id which is in feburary but not in january as of my example which is five

i need expression for this:

Re: need expression

Mon, 08 Oct 2012 20:14:05 GMT

Try this

January:

Load * inline [

January1

];

February:

Load * inline [

February1

];

Test:

Load January1 as January,

January1 as Month

resident January;

join load

February1 as February,

February1 as Month

reisdent February;

test1:

Load

If(February<>January,February) as newid

resident Test;

drop table Test;