Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

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?