topic error in calculated dimension in QlikView

error in calculated dimension

Wed, 09 Feb 2011 23:57:11 GMT

Why do I get error in calculated dimension with this:

=if (Count(distinct NetworkSessionId) > 20, 2, if (Count(distinct NetworkSessionId) > 10, 1, 0 ) )

error in calculated dimension

pover — Thu, 10 Feb 2011 06:40:22 GMT

You can't put any formula in a calculated dimension. The calculated dimension should be an expression that uses the aggr() function or an if() that evaluates a list of values in a field. The formula needs to return a list of values and not a simple count() or sum() that depends on some type of grouping.

Why don't you put this formula as a expression? What of chart or table do you want to create?

Regards.

error in calculated dimension

Thu, 10 Feb 2011 07:42:52 GMT

The code what you are using is not a Measure / expression ......

If you are using it in Dimesion , its ok but there is no Dimesion filed to be Populated.

for example i have dimesion Employee Name and employee Number. then we use

if( employee_Num > 20 , Employee_name)

its should have some dimension to show in that coloumn.

I hope this will work.

error in calculated dimension

Thu, 10 Feb 2011 07:44:30 GMT

PLease provide you feed back tat its woring or not !!!!!!