caluculated dimensions in cyclic groups

Thu, 12 Aug 2010 08:54:49 GMT

I have a pivot table with two cyclic groups as dimensions one called Questiondrill and the other Country/Base/Man (consisting of fields base, country and manager name

My expression is the volume of response.

I need to impose a calculated dimension on the cyclic groups, I have tried to do this within the cyclic group by going edit groups--selecting the appropriate group---edit---selecting the fields that make up the group and using the following dimensions for the country/base/man cyclic group

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

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

=IF(AGGR(Count(IF([Unanswered] ='0', ID)),[Manager Name])>6,[Manager Name])

I have used a similar calculated dimensions for the questiondrill cyclic group as well. However this is not working as I am still getting volume of response less than 6. Please can someone help

Thanks in advance

Rosie

topic caluculated dimensions in cyclic groups in QlikView

caluculated dimensions in cyclic groups