Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
here are some example on different set analysis