symmetric difference

Tue, 18 Aug 2015 15:32:29 GMT

Can anyone help!

I am very new to QlikView and need to replicate some report used by our Retail Security division. Currently they are written in Crystal Reports which are supplied data by a return table from a SQL server user defined function.

I need to perform a symmetric difference on a daily transaction file, each transaction is identified by a Transfer Type ID. In the UDF which returns the data I have created to temporary table one for each type and then perform a join to get the symmetric difference. The Crystal Report then only display records where one side is missing.

From my research it look like I can do this with set analysis, using modifiers the Transfer Type ID's I am interested in. the join in the UDF is shown below.

cast(floor(cast(t10.when_transferred as float))as datetime) = cast(floor(cast(t11.when_transferred as float))as datetime) and

t10.amount = t11.amount

and

t10.cost_centre_cd = substring(t11.additional_data, 1, 4)

My question is how do I use modifiers to identify the data type I require to get the report to work.

Many thanks for any help

Re: symmetric difference

ramoncova06 — Tue, 18 Aug 2015 20:44:50 GMT

here are some example on different set analysis

Set Analysis: syntaxes, examples

topic symmetric difference in QlikView

symmetric difference

Re: symmetric difference