topic calculated dimensions with two drill downs in QlikView

calculated dimensions with two drill downs

Fri, 30 Jul 2010 10:52:44 GMT

Hi I am trying to add a caluculated dimension on a chart which has two drill downs, I have tried using it in the general tab calculated dimension box and in the dimensions but neither is working. Please help

Thanks

Rosie

calculated dimensions with two drill downs

Fri, 30 Jul 2010 11:13:22 GMT

Hi, Can you tell me the expression you are using for calculated dimension. By the way to add calculated dimension go to chart properties -->dimension -->Add Calculated dimension. Remember there is some limitation like you can't use aggregation function in calculated dimension exp.

calculated dimensions with two drill downs

Fri, 30 Jul 2010 11:20:40 GMT

Ok this could be my problem then as I am using an aggregated function here is the caluclated dimension example:

IF(AGGR(Count(IF([Unanswered] ='0', ID),[Questiondrill], [Country/Base/Man])>6,[Country/Base/Man]))

where question drill and country/base/man are drill down groups

I actually want the rule not to report less than 7 responses across all of my tabs is there a way to do this as well?

Thanks in advance

Rosie

calculated dimensions with two drill downs

sparur — Fri, 30 Jul 2010 11:27:07 GMT

Hello, Rosie.

I see a small bug in your expression - you miss one symbol ')' , try use like that:

IF(AGGR(Count(IF([Unanswered] ='0', ID)),[Questiondrill], [Country/Base/Man])>6,[Country/Base/Man]))

calculated dimensions with two drill downs

Fri, 30 Jul 2010 11:33:31 GMT

no unfortunately that doesn't work either. Sorry I should have mentioned before that the groups are cyclic groups rather than drill downs.

Thanks

Rosie