Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

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.