topic Re: Calculated Dimension value different to Expression value in QlikView

Calculated Dimension value different to Expression value

Fri, 08 Mar 2013 12:14:43 GMT

Hi,

Can anyone tell me why I get two different sets of results when I use the same formula as both a Calculated Dimension and an Expression?

Here is the structure of the formula:

if(AuditUpdateID=aggr(num(max(AuditUpdateID,2)),AuditUpdateID,ID),FinancialValue, NULL())

The Calculated Dimension appears to be functioning correctly while the Expression is missing a number of values.

Thanks,

Alan

jonathandienst — Fri, 08 Mar 2013 12:26:04 GMT

Alan

Possibly because the expression is being influenced by other dimensions on the object, whereas the dimension is not?

Jonathan

Fri, 08 Mar 2013 13:25:42 GMT

Thanks Jonathan.