Hi all,
I have created the below formula in excel to help understand the numbers of errors within a particular data set:
I then tried to re-create this within QlikView as per the below but I am not getting the same results
IF(IF(IsNull([Cancellation Received by OG]) or [Cancellation Received by OG]=' ',0,1)=1
and IF(IsNull([Affirmation(s) Received by OG]) or [Affirmation(s) Received by OG]=' ',0,1)=1
and [Version]<=1, 0,1) as OMGEO_ERROR_TRADE,
I created the above within the script and tried using the below as my dimensions and expressions to create a stacked chart by month with the volume of accurate and error trades.
Dimensions
1. Month
2. (Calculated) - if([ERROR]=1, 'Accurate', 'Error')
Expression
Count(Reference)
Many thanks in advance,
Matt
