topic Re: column() by name not number? in QlikView

column() by name not number?

Tue, 23 Feb 2016 14:40:34 GMT

I thought this would be easy to find via search, but no dice. I have a straight table/chart that uses column() references in its expressions -- e.g. Cost * column(1). I want to refer to columns not by number but by name (label). Further, many of my column names use expressions. So I might have a column label set to...

="Usage" & chr(10) & vMonth

Part of the problem is users clicking and dragging column headers around to reorder the columns (sometimes inadvertently). This throws off some of the calculations. Rewriting the expressions to not use column references isn't really an option.

Is there a way? Thanks.

Re: column() by name not number?

sunny_talwar — Tue, 23 Feb 2016 14:43:09 GMT

The changing nature (because you use expressions for column label it seems) of the column label might make it difficult, if not impossible, to refer the label names in your expression. May be use the actual expressions or put the expression in a variable and use variable to do what you are doing with the expression labels.

Re: column() by name not number?

swuehl — Tue, 23 Feb 2016 14:49:22 GMT

Try

="$(='Usage' & chr(10) & vMonth)"

Re: column() by name not number?

luciancotea — Tue, 23 Feb 2016 14:50:55 GMT

One solution is to block the columns rearranging:

Straigt Table -> Presentation -> Allow Drag and Drop

Pivot -> Presentation -> Allow Pivoting

But usually I write expressions without referencing other columns.

Re: column() by name not number?

Anonymous — Tue, 23 Feb 2016 15:04:42 GMT

Hi,

Try this in your expression :

$(='['&"Usage" & chr(10) & vMonth&']')

Re: column() by name not number?

Fri, 26 Feb 2016 18:10:21 GMT

Excellent. Thank you.