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
