Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

ColumnNo() Error in Set Analysis


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.

Tags (3)
1 Reply
Valued Contributor II

ColumnNo() Error in Set Analysis


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.



Community Browser