topic With a dynamic column, refer to column using a system variable in QlikView

With a dynamic column, refer to column using a system variable

mellerbeck — Fri, 05 Aug 2011 17:42:34 GMT

This is just more of a question for curosity sake. But,

I have a list box that contains values for a column let's say

columnA

columnB

This is called [Column Name]

So on the conditional show column\hide

I use this expression to show or hide based on whether they are selected in the [Column Name] list box

SubStringCount(GetFieldSelections([Column Name], ',' ,Count(Distinct [Column Name])), 'columnA')

My question is, instead of using columnA is there anyway to use a variable to reference the column that this expression is applying to. I would think the expression would know what column it is being applied to?

Anyways, any thoughts?

With a dynamic column, refer to column using a system variable

rwunderlich — Fri, 05 Aug 2011 18:40:02 GMT

What you are looking for is something like a "this" operator or self-reference. I've often wanted that myself. As far as I know it doesn't exist in the product.

-Rob

With a dynamic column, refer to column using a system variable

mellerbeck — Fri, 05 Aug 2011 18:52:16 GMT

Yes, it would be a this or maybe a me type operator.