topic columnnsames including [] in QlikView

columnnsames including []

Tue, 19 Oct 2010 13:23:39 GMT

Hi,

i have columnnames including sqare brackets (like "Netto [T€]". How can I use them in expressions i.e. rangesum([Netto[T €]], above([....])).

Any Ideas ?

Regards

Roland

boorgura — Tue, 19 Oct 2010 13:48:45 GMT

Hi Roland,

if I get it right - column name you are talking is the expression name - right?

If so you can use the column reference.

like column(1)+column(2)

Let me know if it helps.

john_duffy — Tue, 19 Oct 2010 13:51:48 GMT

Hi Roland.

You should be able to put the column names in double quotes when using them in expressions - eg. rangesum("Netto [TE]").

John.

Tue, 19 Oct 2010 14:03:12 GMT

Hi Rocky,

thank you for your answer. Sorry, of course I mean expression names, and to be even more correct: expression labels.

I know the possibility using column(1), .... . But what if endusers rearrange the columns in the chart? Then it leads to funny results.

regards

Roland

Tue, 19 Oct 2010 14:05:21 GMT

Hi John,

it works. Sometimes life is easy, if you know what I mean.

Thanks

Roland