Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
elijahabel
New Contributor III

Is referencing columns in formulas as [column name] valid?

I've noticed that in Qlik sense, you can directly reference other columns in your calculation by inserting [column name] into a formula. My issue is that any time you do this, you always get a red outlined formula box indicator, even though the numbers are coming correctly. Is there a case in which this will not work? The red outlining leads me to believe it's unstable, but so far it seems like it works. Should I avoid using it this way?

Example:

Col1Col2[Col1]-[Col2]
13-2
523
725

The calculations will be correct, but the expression box for [Col1]-[Col2] will have a red outline indicating it is invalid.

Tags (2)
1 Solution

Accepted Solutions

Re: Is referencing columns in formulas as [column name] valid?

From what I know from QlikView, column reference doesn't work with Aggr() function. Otherwise it should work without issue

View solution in original post

2 Replies

Re: Is referencing columns in formulas as [column name] valid?

From what I know from QlikView, column reference doesn't work with Aggr() function. Otherwise it should work without issue

View solution in original post

Highlighted
elijahabel
New Contributor III

Re: Is referencing columns in formulas as [column name] valid?

Thanks for the input! This clears up why it is highlighted. Do you know of any non-static way to refer to columns in calculations? I know that Column(0)-Column(1) would also work here, but if we have self-service capabilities, this means the users cannot move rearranged columns without messing up calculations.