topic Re: exception scenario in QlikView

exception scenario

rdsuperlike — Wed, 04 Nov 2015 20:35:52 GMT

Hi,

I have attached below file. I want to see all the unconnected data.

I have been able to put logic at script end which says that 0 means unconnected but 1 means connected.

But since its a 2 level check in data model

fab --> maping --> main_mapping

I am not able to display union of unconnected records from fab to maping and maping to main_maping.

basically if flag = 0 then it is unconnected or if flag_main_maping = 0 then unconnected. When I put a list box and select them individually it comes properly. But I want to see them all 3 unconnected record together.

I want to see below result at one go :

field1	field11	field22	field32	fieldx	flag	flag_mainmap_to_map
b	21				0
e	58				0
d	43	4HTC		u	1	0

Any help is appreciated

Re: exception scenario

swuehl — Wed, 04 Nov 2015 20:50:30 GMT

Maybe like attached (check the expression in the straight table)?

Re: exception scenario

rdsuperlike — Wed, 04 Nov 2015 21:51:16 GMT

Can you explain the logic?

Re: exception scenario

swuehl — Wed, 04 Nov 2015 22:05:10 GMT

The expression is

=NOT (alt(flag,1) AND alt(flag_mainmap_to_map,1))

The alt() function is only used to provide flag values for each line, NULL / MISSING will be replaced with 1.

Both flags are used as operands in AND logic, when both flags are 1, result is TRUE.

NOT will negate the result, if both flags are 1, result is TRUE, negated it's FALSE (zero as number).

If one or both flags are zero, the AND will return FALSE, negated to TRUE.

The straight table with option in presentation tab 'suppress zero values' enabled will only show lines where the expression evaluates to TRUE (not zero).

You can create expressions for every part of above expression to see what each part returns.