Convert excel formula to Qlikview "language" conundrum (stacked chart)

Fri, 11 May 2012 12:58:19 GMT

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

topic Convert excel formula to Qlikview "language" conundrum (stacked chart) in QlikView

Convert excel formula to Qlikview "language" conundrum (stacked chart)