Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

carpentiere
New Contributor II

Calculation between columns in a QlikSense table

Hello,

While in QlikView it is easy to perform calculations between the columns of an array, I have not found how to do with QlikSense.

With qlikView, columns labels can be used for calculations.

1.JPG

With QlikSense, I only found the column () function, but the disadvantage is that moving the columns requires modifying the formulas.

2.JPG

Would someone have a solution?

Regards,

1 Solution

Accepted Solutions
saniyask
Contributor

Re: Calculation between columns in a QlikSense table

Hi,

It works quite similar to Qlikview, use the label name in the expressions and check. PFB images.

Regards,

Saniya.

3 Replies
saniyask
Contributor

Re: Calculation between columns in a QlikSense table

Hi,

It works quite similar to Qlikview, use the label name in the expressions and check. PFB images.

Regards,

Saniya.

shraddha_g
Honored Contributor III

Re: Calculation between columns in a QlikSense table

I doubt..

But 1 option is create variables with those expressions and then use those variables in expression

carpentiere
New Contributor II

Re: Calculation between columns in a QlikSense table

Hi Saniya,

You are right.

My error was that i thought it was wrong because the expression was red rounded (as it was false).

Best to use square bracket to delimit Columns labels

3.JPG

Regards,