Referencing columns when previous columns are hidden

Anonymous — Mon, 15 Oct 2012 10:58:55 GMT

Hi,

I have some P&L and Balance Sheet straight/pivot tables that show both absolute and relative differences between columns. These differences are calculated using Column(ColumnNo) type syntax, as opposed to either the columns' expressions (which would be too messy to maintain) or labels (which are dynamically calculated with dates or determinantion of whether Full Months or MTD etc.).

I am now testing for whether Budget data has been loaded (as this is a template I'm deploying across multiple companies with the same ERP data source). If budget data doesn't exist the Budget and comparisons to Actual columns are to be hidden on the Presentation tab (with the calculation of the columns seemngly also needing to be made conditional on the Expressions tab).

This attempt at standardisation and flexibility is causing me problems however when calculating comparison between columns appearing after these hidden and not calculated budget columns. Can anyone advise is there is another way of setting up a name of a column. Do columns have codes that can be set and not changed, which are neither the labels shown to users or the column positions ?

Thanks,

Jonathan

Re: Referencing columns when previous columns are hidden

Anonymous — Wed, 17 Oct 2012 06:40:30 GMT

I got a working solution via another message I posted http://community.qlik.com/message/270347#270347, using variables for the labels instead of column numbers of the label text.

topic Re: Referencing columns when previous columns are hidden in QlikView

Referencing columns when previous columns are hidden

Re: Referencing columns when previous columns are hidden