Add calculated dimension

Tue, 18 Dec 2012 16:10:15 GMT

Hello;

I am trying to add a calculated dimension to a chart and the legend returns an error.

The statement used works well in an expression but not in the dimension side.

Any idea why?

This is the statement in question.

=if(

(If(ActivityType='INEN'OR ActivityType='ISSS'OR ActivityType='IDOA',1,0))

(if(((SUM(_Hours_worked))/[Target Inst Hours])>0 and ((SUM(_Hours_worked))/[Target Inst Hours])<0.3 or ((SUM(_Hours_worked))/[Target Inst Hours])>1.5,1,0))>0,'Problem','No Problem')

Many thanks in advance for your answer.

Kristel.

Re: Add calculated dimension

vgutkovsky — Tue, 18 Dec 2012 16:50:45 GMT

If you want to use aggregation in a calculated dimension, you will need to wrap it in an aggr() function--remember, that at the dimension level, QlikView does not yet know what dimension it should be aggregating across, so requires an explicit aggr() definition.

Regards,

Vlad

topic Add calculated dimension in QlikView

Add calculated dimension

Re: Add calculated dimension