topic Re: Count Value from table comparison in QlikView

Count Value from table comparison

Mon, 01 May 2017 13:06:37 GMT

Two tables. Trying to get an expression to compare the two and give me the results of the ones missing a match

Qualify *;

Access: LOAD * INLINE [Group, Path

d, ];

Unqualify *; Qualify *;

Type: LOAD * INLINE[Group, Type

a, REG

b, REG

d, SPEC];

Expression as I understand it would be something like:

count(distinct if(Type.Group<>Access.Group and Type.Type='Reg', Access.Group))

Doesn't work for me at all. I want it to look at all of fields in Type.Group and show me Access.Group that doesn't exist in Type.Group.

marcus_sommer — Mon, 01 May 2017 14:30:14 GMT

Without the qualify-stuff it would be easy with:

- Marcus

Digvijay_Singh — Mon, 01 May 2017 15:07:15 GMT

try this -

Access:

Load Group, Path;

LOAD * INLINE [ Group, Path

a, "c:\dir1"

b, "c:\dir2"

c, "c:\dir3"

d, "c:\dir4" ];

Type:

Load Group as TempGroup, Type;

LOAD * INLINE [Group, Type

a, REG

b, REG

d, SPEC];

Notmatch:

Load Group as Group1, Path as Path1

Resident Access

Where Not exists(TempGroup,Group);