topic Compare data expression in QlikView

Compare data expression

guya — Mon, 29 Nov 2010 12:46:50 GMT

Dear all,

I need to compare two data from each order line and add new column saying 'Matched' if the difference is less than 1 and 'NotMatched' if the difference is more dans 1.

eg: if a = 254.23 and b = 254.40 then the new column will show 'Matched'

if a = 135.45 and b = 137 then 'NotMatched'

Is it possible to do this using set analysis or in the script somehow.

Thank you for your support,

Guy

Compare data expression

Mon, 29 Nov 2010 13:40:39 GMT

Hi Guy,

I would do that in the load - script like this:

LOAD . . . IF ( (a - b) < 1, 'Matched', 'NoMatch') AS MATCH_COLUMN; ....

Regards, Roland

Compare data expression

guya — Mon, 29 Nov 2010 14:10:46 GMT

The field a & b are located in two different tables. What will be the LOAD synthax?

With many thanks

Guy

Compare data expression

Mon, 29 Nov 2010 14:48:21 GMT

Hello again,

then you need to join (not a SQL-Join but a QV-Join) the correspondending tables temporarily together. Therefor you need a unique matching key. If you don't have it, you are in trouble. The attached sample application points into the right direction. Table1 will get a new field called Match_Col.

Regards Roland

Compare data expression

guya — Mon, 29 Nov 2010 15:56:50 GMT

Thank you very much Roland - That's works fine

Guy

Compare data expression

Mon, 29 Nov 2010 16:34:16 GMT

Hi Guy,

glad to help you. Don't hesitate to post again.

Would you mark my answer as the one which solved the problem, too.