comparing values from dynamic fields (set analysis)

andreacs — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to compare field values from two tables. Fields name could change so I need to use a variable approach to compare the fields dynamically.

DIMENSION: %field

EXPRESSION1: =only({1} %field)

EXPRESSION2: =COUNT(if($(='[NEW.'&%field&']')<>$(='[OLD.'&%field&']'),KEY))

The expression2 works fine if I select a value from %field but i would like to show the result for each fields (ignoring selections in %field).

I try something like this but it doesn't work:

EXPRESSION2: =COUNT(if($(='[NEW.'&only({1}%field)&']')<>$(='[OLD.'&only({1}%field)&']'),KEY))

please help me with this last expression

thank you!

*****************************************************

this is the script:

Qualify *;

Unqualify KEY;

OLD:

LOAD KEY,

FIELD1,

FIELD2,

FIELD3,

FIELD4

FROM

C:\OLDFILE.xlsx

(ooxml, embedded labels);

Unqualify *;

Qualify *;

Unqualify KEY;

NEW:

LOAD KEY,

FIELD1,

FIELD2,

FIELD3,

FIELD4

FROM

C:\NEWFILE.xlsx

(ooxml, embedded labels);

Unqualify *;

FIELD_NAME:

LOAD *

Inline "

%field_old_sel, %field_new_sel, %field

[OLD.FIELD1], [NEW.FIELD1], FIELD1

[OLD.FIELD2],[NEW.FIELD2],FIELD2

[OLD.FIELD3],[NEW.FIELD3],FIELD3

[OLD.FIELD4],[NEW.FIELD4],FIELD4

topic comparing values from dynamic fields (set analysis) in QlikView