ColumnNo() Error in Set Analysis

Wed, 07 Dec 2011 02:10:23 GMT

Hi,

I have this script in a pivot table.

count({<EffectiveYear={2011},EffectiveWeek={$(=ColumnNo())}>} TOTAL [Employee Number])

But unfortunately, ColumnNo() is not recognized properly by set analysis.

I have tried placing RowNo() and it works as well as placing constant.

ColumnNo() Error in Set Analysis

fosuzuki — Wed, 07 Dec 2011 15:44:35 GMT

Hi,

I think that the problem is that QlikView first evaluates the Dollar-Sign Expansions to get the final expression, and after tries to calculate the value for each row/column. So QlikView is using the following expression:

count({<EffectiveYear={2011},EffectiveWeek={-}>} TOTAL [Employee Number])

, which returns you invalid data.

Trty replacing the expression for this:

count({<EffectiveYear={2011}, HireWeek=p(EffectiveWeek)>} [Employee Number])

I'm not sure of what you want, so it may be incorrect....

Hope this helps you.

Regards,

Fernando

topic ColumnNo() Error in Set Analysis in QlikView

ColumnNo() Error in Set Analysis

ColumnNo() Error in Set Analysis