topic Re: table with duplicate column names in QlikView

table with duplicate column names

Wed, 25 Nov 2020 16:16:04 GMT

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!

Gysbert_Wassenaar — Thu, 28 Apr 2016 17:18:59 GMT

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]

Thu, 28 Apr 2016 17:35:57 GMT

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 — Thu, 28 Apr 2016 17:45:58 GMT

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

Gysbert_Wassenaar — Thu, 28 Apr 2016 17:47:39 GMT

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

Thu, 28 Apr 2016 17:56:56 GMT

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 — Thu, 28 Apr 2016 18:02:12 GMT

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

Thu, 28 Apr 2016 18:04:48 GMT

thanks again,

my last q: where can I read about it?

Gysbert_Wassenaar — Fri, 29 Apr 2016 14:10:42 GMT

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.