Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

nicolaipj
Contributor

Use of FieldValue('Field', ColumnNo()) in set expression

Hi

For a number of reasons, I don't want to let my pivot table object "handle" my second dimension as a horizontal dimension as one would normally do.

Instead, I would like to have a number of identical expressions, with my exprea formular that with a set expression does a simple count, looking up a field:

I can get this to work:
=count({1<TYPE = P(), CATEGORY = {$(=FieldValue('CATEGORIES', 1 ))}>} DISTINCT ID)

But not the dynamic one:

=count({1<TYPE = P(), CATEGORY = {$(=FieldValue('CATEGORIES', ColumnNo() ))}>} DISTINCT ID)

I suspect I am missing something with ColumnNo() and have tried enclosing with $(=) and alike, but have not succeeded.

Any help with this one?

/Nicolai

2 Replies
nicolaipj
Contributor

Use of FieldValue('Field', ColumnNo()) in set expression

Alright...the columnno() only works over dimension, and not over let's say 4 different expressions.

Any way of fetching the expression number in a pivot or the column number in any other ways?

nicolaipj
Contributor

Use of FieldValue('Field', ColumnNo()) in set expression

Which by the way, seems a little odd, when you can get the result of the other expressions using column(x), so they must have a number. Any ideas?

Community Browser