table with duplicate column names

[#1]

Hi,

I have two questions need help with:

1.I have a table with two calculated "Actuals". How to specify which one to use in "YTD Remaining" calculation.

2. If I rename second "Actual" to 'YTD Actual" then I can't use is in calculations, Qlik doesn't like the space.

Is the a way to use column name and not the label in calculations?

Thanks for your help!

L

[Gysbert_Wassenaar]

1a. Give it another name

1b. Use the column number: Column(1)+Column(4)/Column(15)

2. Use square brackets around the column name: [Actuals YTD]

[#3]

Thanks Gysbert,

It is user requirement to have the same names so I used 1b and it works.

Is there a property to see column numbers? 

[jolivares]

I prefer to use the expression as well instead of titles, in this case this not an issue.

[Gysbert_Wassenaar]

No, there isn't. Just count from left to right.

[#6]

One more q:

my calculation for "YTD Remaining" worked when I used second "Actuals" as column (5): 

        Budget - Column(5) - Commitments

Why?  Is Department not a numbered column?

[Gysbert_Wassenaar]

That's correct. Only expression columns can be referrenced by number. You can reference dimensions by their field name.

[#8]

thanks again,

my last q: where can I read about it?

[Gysbert_Wassenaar]

In the help file in the Chart Inter Record Functions section

Column(ColumnNo)                                                                                                                                

Returns the value found in the column ColumnNo in a straight table or a pivot table.

Example:

column(1)/column(2) returns the quotient.